Try our new research platform with insights from 80,000+ expert users
it_user436125 - PeerSpot reviewer
Lead Product Dev at a tech company
Vendor
I think that the most valuable feature of Oracle Database is the knowledge base that's available.

What is most valuable?

I think that the most valuable feature of Oracle Database is the knowledge base that's available. If there's a bug, I can find the solution in the knowledge base. If I need to know why something's happened, or whether there's a workaround, I can find the solution in the knowledge base. There's a wealth of information available there, and I live and die by it.

How has it helped my organization?

Our core business relies on its ability to work with RDBS. You could say that we make all our money by using Oracle. Since version 8i, it's been my bread and butter. I love the product and use it every day.

What needs improvement?

The features that are there, it usually works perfectly. The new features, you see that it takes some time to pick up and sometimes they break things they really shouldn't.

For how long have I used the solution?

I've been using it since Oracle 8i, which was 18 years ago.

Buyer's Guide
Oracle Database
March 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.

What was my experience with deployment of the solution?

We've had no issues with deployment.

What do I think about the stability of the solution?

Oracle has added a new optimizer option to do some very fancy stuff, but it provides the wrong results. And at this stage in the life of the product, wrong results should never happen. That's why I have Database -- to get the correct results.

What do I think about the scalability of the solution?

It scales very well. With NoSQL though, there are scalability issues because it just cannot spin up. But I've found that with Hadoop and AWS, you can spin up to 2,000 new nodes and it works fine. You can't do that with Oracle, but it's legacy software nowadays.

How are customer service and support?

Technical support is fine. Fortunately, we don't have any priority-one issues within our business that depend on Oracle Database. For minute-to-minute operations, I get a good enough response from technical support.

As a vendor, we support older versions and the customer will never touch them. I really don't need to ask technical support for a fix, I know that the customers will not use it.

Which solution did I use previously and why did I switch?

We haven't used a different RDBMS since I started with the company.

How was the initial setup?

The initial setup was done before I started my current position.

What about the implementation team?

The implementation was done before I started my current position.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
PeerSpot user
reviewer1829532 - PeerSpot reviewer
Senior Developer Individual Contributor at a tech services company with 501-1,000 employees
Real User
A well-developed solution with excellent partitioning
Pros and Cons
  • "Partitioning is the most valuable feature."
  • "It would be useful if I could connect to an expert for one-on-one help."

What is our primary use case?

I mainly use this solution for data warehouse applications, report generation, and transactional data processing.

What is most valuable?

Partitioning is the most valuable feature.

What needs improvement?

It would be useful if I could connect to an expert for one-on-one help.

For how long have I used the solution?

I've been using Oracle Database for more than twenty years.

What do I think about the stability of the solution?

Oracle Database is stable and reliable.

How was the initial setup?

The basic initial setup was straightforward, but a professional would be required if the solution needed to be fine-tuned.

What was our ROI?

I've seen a good ROI.

What's my experience with pricing, setup cost, and licensing?

Oracle Database is expensive.

What other advice do I have?

I would recommend Oracle Database to others - it's a well-developed solution and is accepted on the market. I would give it a rating of eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: partners
PeerSpot user
Buyer's Guide
Oracle Database
March 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
reviewer1662204 - PeerSpot reviewer
IT Manager at a construction company with 1-10 employees
Real User
I'm happy with the performance
Pros and Cons
  • "Oracle Database is stable. I'm quite happy with the performance."
  • "The price should be lower."

What is our primary use case?

We're using Oracle Database for corporate enterprise resources planning, manufacturing systems, etc. It's deployed in a Red Hat Linux environment.

For how long have I used the solution?

I've been using Oracle Database for about 15 years.

What do I think about the stability of the solution?

Oracle Database is stable. I'm quite happy with the performance.

What do I think about the scalability of the solution?

Oracle Database is scalable. We're running it on around 250 devices.

Which solution did I use previously and why did I switch?

We previously used some small-scale SQL servers running Microsoft SQL Server for access control.

How was the initial setup?

Installing Oracle Database is straightforwad. 

What's my experience with pricing, setup cost, and licensing?

The price should be lower. We're currently paying for it yearly.

What other advice do I have?

I rate Oracle Database 10 out of 10. I would definitely recommend it.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1674894 - PeerSpot reviewer
Data Quality Specialist at a healthcare company with 5,001-10,000 employees
Real User
Intuitive interface and easy to use, but monitoring processes could improve
Pros and Cons
  • "The interface of Oracle Database is very workable and easy to use."
  • "The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them."

What is our primary use case?

Most of the use cases for Oracle Database I was involved in were for data migration. I was performing analysis and writing scripts to support the data migration from one data model to a new data model within the database. I wrote PVT scripts to test to make sure that the actions expected were all completed correctly. Additionally, I did ad hoc analysis in Oracle Health data quality issues and potential issues.

What is most valuable?

The interface of Oracle Database is very workable and easy to use.

What needs improvement?

The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them.

For how long have I used the solution?

I have used Oracle Database for approximately one year.

What do I think about the stability of the solution?

The solution is reliable and stable.

What do I think about the scalability of the solution?

We have approximately 10 to 100 users using the solution in my organization.

What about the implementation team?

I work in a medium to large enterprise and there are dedicated teams that do the implementation and maintenance of the solutions.

What other advice do I have?

I would recommend this solution to others. It is a good performing database on medium to large data sets. The SQL Developer is a full-function user interface.

I rate Oracle Database a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
SAMUELMWANGI - PeerSpot reviewer
Director at Calidad Systems Limited
Real User
Easy to scale, easy to use, and has good support
Pros and Cons
  • "Oracle Database is easy to use."
  • "I would also like to see more features added and the stability needs improvement."

What is our primary use case?

We use this solution as the core database in the banking and insurance systems.

What is most valuable?

Oracle Database is easy to use.

What needs improvement?

I would like to see more security included.

I would also like to see more features added and the stability needs improvement.

For how long have I used the solution?

I have been using Oracle Database for five years.

We are using the latest version.

What do I think about the stability of the solution?

The stability of the Oracle Database needs to be improved.

What do I think about the scalability of the solution?

Oracle Database is a very scalable product.

How are customer service and technical support?

Technical support is great, but it can be faster.

Which solution did I use previously and why did I switch?

Our users have used Windows 10.

I have used Oracle Linux for six years.

How was the initial setup?

For someone who has used Oracle, before it's easy.

We have a DBA and our technical team of six who maintain this solution.

What's my experience with pricing, setup cost, and licensing?

The license fee is paid annually.

The fees are another area that can be improved. The pricing should be cheaper.

What other advice do I have?

I would recommend this solution to others.

I would rate Oracle Database a nine out of ten. Because we work in banking and insurance systems, many people use this solution.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Technology Manager at OrchidaSoft
Real User
Easy to set up with lots of features and in general good to work with
Pros and Cons
  • "The initial setup isn't too difficult."
  • "The main issue with Oracle is the maintenance required."

What is our primary use case?

We use this solution based on the requirements of a client.

How has it helped my organization?

We primarily use it for a client that has a huge amount of data and has another application that also has lots of data. It's very good at handling jobs that have huge datasets.  

What is most valuable?

I'm not a regular user of the solution.

It's a great product overall.

The initial setup isn't too difficult.

The product does have a lot of features. However, I've barely explored them.

What needs improvement?

The main issue with Oracle is the maintenance required. They should work to make it less maintenance-heavy. This is especially true if you are using it on Linux. You need more experience and skills in order to maintain it on Linux in general.

We've had corruption occur if the power gets cut off. We had a bad experience with some cases. However, this might have been due to our own infrastructure issues that have since been dealt with.

For how long have I used the solution?

We've used the solution for three or four years.

What do I think about the scalability of the solution?

The solution isn't widely used by our company. I'm the only one testing it. The people in our company don't use Oracle at all.

How are customer service and technical support?

I've never directly dealt with technical support. I cannot speak to how helpful or responsive they would be. Whenever I have a problem or issue, I google it and search for answers online. 

How was the initial setup?

While I don't have much personal experience, my understanding is that the initial setup isn't too difficult. It's pretty simple and straightforward.

In our organization, we don't use Oracle, aside from in labs. We use Oracle in our labs just for testing and connectivity. We have versions of Oracle in our labs and other SQL devices.

What's my experience with pricing, setup cost, and licensing?

We don't really use the solution too much in the company and therefore don't have a license. We test it for customers. I can't speak to the licensing process or costs. 

What other advice do I have?

I'd rate the solution at an eight out of ten. It's mostly been a positive experience, working with the product.

Between Oracle and SQL, I would recommend SQL to other users and companies. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1510626 - PeerSpot reviewer
Web Developer at a government with 10,001+ employees
Real User
Stable, simple to set up and is much more organized in the latest version
Pros and Cons
  • "The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now."
  • "The previous version was a little clunky."

What is our primary use case?

Once we get the installation done, we migrate items to our new DB and we maintain the service with tasks such as clearing the caches and taking the backups, and checking the logs. We look at what it's doing - if something's wrong or if there are any kinds of issues. Occasionally, we do some performance tuning.

What is most valuable?

The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now.

The initial setup was pretty simple.

The solution is pretty stable.

What needs improvement?

The previous version was a little clunky. 

I'm not exactly experienced in troubleshooting. There are issues that I can't really fix. Sometimes I'm helpless with Google also. Trying to learn to identify the exact issue I was getting a Boolean error. I need to improve my knowledge. I'd like to have more documentation or assistance in this area.

The solution could be more user-friendly,

For how long have I used the solution?

I've been using the solution for five or six years. It's been a while.

What do I think about the stability of the solution?

It's a wonderful product. Those that have a lot of experience working with the product, those with ten or 15 years of experience, will be able to understand its core processes. Those with only a few year's experience will feel there's a certain lack of transparency.  That said, I haven't had any issues with bugs or glitches, and when it is set up correctly, it doesn't crash or freeze.

How was the initial setup?

The initial setup is not complex or difficult. It's straightforward and pretty easy to set up.

If you are experienced it is an easy task for you, however, it is a process. We have to check every step. If we've done something wrong in any step, then the whole installation process will be for nothing. New errors will come up. We have to document everything and we have to have the requirements clearly laid out. I've learned the hard way that you cannot take shortcuts.

What other advice do I have?

We're just a customer and an end-user. We don't have a business relationship with Oracle.

We have our primary DB on Oracle 19C.

We have to manage everything, including the frontend and backend.

I'd rate the solution at an eight out of ten. If it was more user-friendly, I would rate it higher.

I would recommend Oracle Database to others. We have some colleagues who are doing some small-scale businesses. For them, it might not be suitable. Not everyone should get into Oracle. It is a standard product, however, you need to understand your exact requirements. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Associate Consultant Oracle DBA at ATOS GITSS Pvt. Ltd.
MSP
Top 20
Good recovery manager, but needs support services for more production access
Pros and Cons
  • "The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager)."
  • "This product would be improved with Support Services for more production access."

What is our primary use case?

Our primary use for all Oracle Activity is to maintain and monitor six database servers.

How has it helped my organization?

For the past nine years, we have been supporting our client's company database fully with developer and database support.

What is most valuable?

The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager).

What needs improvement?

This product would be improved with Support Services for more production access.

For how long have I used the solution?

Four years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.