Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Advisory Software engineer at a tech services company with 1,001-5,000 employees
Consultant
Its cross-platform compatibility provides flexibility for different platforms like Windows, Linux, Solaris, HP-UX, and AIX.

What is most valuable?

The best thing about Oracle Database is that it performs well when measured on any scale. As a Database developer, I think it offers the best development tools of any database solution.

How has it helped my organization?

Its cross-platform compatibility provides flexibility for different platforms like Windows, Linux, Solaris, HP-UX, and AIX. Oracle offers high-performance handling of XML data.

What needs improvement?

We are currently using Oracle 11g, where as Oracle 12c now has all the major features for easy development. However, as the database industry is growing, there is room to enhance object reusability by introducing some development framework or out-of-the-box concepts.

For how long have I used the solution?

I've used it for 12 years.

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

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

We had no issues with the stability.

What do I think about the scalability of the solution?

It is scalable. Indeed, you don’t have to worry about scalability as this is Database's strength -- it grows with your business and is an all-in-one solution.

How are customer service and support?

I have had some discussions with a few DBAs. Oracle technical support is not very good compared to Microsoft technical support, the latter of which is more proactive and reachable. Secondly, Oracle technical support is more costly than its competitors.

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

I also have worked as a developer on Microsoft Dynamics AX with SQL server. The main reason we changed was because of the AX Dynamics cost - initial cost, customization, and maintenance. It is much lower than Oracle Database.

As with any vendor resource, availability is also a major issue for Oracle. As there is a lot of development flavors for Microsoft, resources are easily available and it's more flexible to work with on different technology. In comparison, Oracle resources are scarce and are mostly away from new market trends.

How was the initial setup?

The complexity of the initial setup depends, as it is a self-manageable database for small databases, whereas for mid and enterprise levels, it needs serious attention.

What was our ROI?

The cost of Oracle Database is a little higher than competitor products, but it gives good ROI in the longer run.

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

For long term investment, it is the best option. Initially, its cost is higher, but its running cost is less than other competitors.

What other advice do I have?

This is the best database product on the market.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user419154 - PeerSpot reviewer
Database Manager at a tech services company with 501-1,000 employees
Consultant
The performance is valuable, especially when compared to MySQL or DB2.

Valuable Features

It's pretty impressive how much data we can manage and how fast we can do it with Oracle DB. The performance is also valuable, especially when compared to MySQL or DB2.

Improvements to My Organization

We handle vast amounts of data and we need to access it quickly. Oracle DB allows us to be able to do that. Again, that's impressive to us.

Room for Improvement

I don't like the user interface. I prefer to work with a console and proper lines, which, for me, is the easier way to operate Oracle DB. The current way that things are done is much more tortuous.

Deployment Issues

We haven't had any issues with deployment.

Stability Issues

Oracle DB has been very stable for us, especially since it has provides us with backups. But it needs people to manage it, so you have to pay attention to properly staffing it once implemented.

Scalability Issues

It's very scalable and, in fact, scales beautifully. All we've had to do is create more than one instance, which is very easy to do.

Customer Service and Technical Support

I had an ORA-0600 error which initially didn't "exist" because it wasn't mapping with technical support. It took them some time to resolve the issue.

Initial Setup

The initial setup was easy and straightforward. It required only a few clicks.

Implementation Team

We implemented it ourselves at it was so easy to do.

Other Advice

I think it's the best database technology on the market. I recommend it to anyone considering it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database
February 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
reviewer1406625 - PeerSpot reviewer
System Specialist at a university with 501-1,000 employees
Real User
Easy to use and install, but the security and support need improvement
Pros and Cons
  • "Oracle Database is easy to use."
  • "Security is an area that needs to be improved."

What is our primary use case?

This solution is used for the collection of data.

What is most valuable?

Oracle Database is easy to use.

What needs improvement?

Security is an area that needs to be improved. 

For how long have I used the solution?

I have been using Oracle Database for years.

We are using version 12.2

What do I think about the stability of the solution?

Oracle Database is a stable product.

What do I think about the scalability of the solution?

We have several thousand users in our organization. 

How are customer service and technical support?

The support response time could be faster.

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

Previously, we used IBM Db2.

We used IBM Db2 within the last year.

How was the initial setup?

The initial setup was straightforward. It was easy to install.

What other advice do I have?

I would recommend this solution to others who are interested in using it.

I would 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
reviewer1503396 - PeerSpot reviewer
BU Delivery Head at a tech services company with 10,001+ employees
Real User
Robust, with good security capabilities, but the programming interface needs improvement
Pros and Cons
  • "I like the backend robustness of the database, and the security capabilities inherently that are in the product itself."
  • "The adaptability to various APIs is something that needs to be improved."

What is most valuable?

I like the backend robustness of the database and the security capabilities that are inherently in the product.

What needs improvement?

The adaptability to various APIs is something that needs to be improved.

Also, the programming interface needs some improvement.

For how long have I used the solution?

I have been using Oracle Database for five years.

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

We typically use Oracle Suite for our databases and Microsoft for our OS platforms. 

We are also considering a partial move to Microsoft Azure. This is our plan but it has not yet happened.

What other advice do I have?

We are currently evaluating solutions to purchase. Some of the solutions that we are considering are AlgoSec, Skybox, and Toughen.

We are currently managing our firewall manually, which is why we are looking for an automated tool.

I would rate Oracle Database a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1463181 - PeerSpot reviewer
Sr. Professional Security Compliance at a computer software company with 10,001+ employees
Real User
Endless capacity and a stable platform; licensing formulation is unfortunately complicated
Pros and Cons
  • "The solution has an endless capacity."
  • "The licensing formulation is too complicated."

What is our primary use case?

We use this solution as a customer database for our client so all customer information is available through this product. I'm a senior professional security compliance officer and we are partners with Oracle. 

What is most valuable?

I like that the solution has an endless capacity, there are no limitations and it's a stable platform. 

What needs improvement?

The licensing formulation could be improved; it's too complicated and very rigid. 

For how long have I used the solution?

I've been using this solution for a very long time. 

What do I think about the stability of the solution?

It's a stable solution but there are bugs which I think is related to standards compliance. There are limitations in monitoring. 

How are customer service and technical support?

Technical support is somewhat limited. 

How was the initial setup?

The initial setup was complex. Compared to the implementation of Microsoft SQL, we needed skilled people to manage Oracle. Implementation took some weeks. 

What other advice do I have?

I think this is a good solution because it's easy to administer and manage but it requires the right skilled people. It's not ideal for our requirements but it's improving, whether it's encryption or security, I know they'll get there eventually. 

I would rate this solution a seven out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
it_user521568 - PeerSpot reviewer
Principal Software Architect at a transportation company with 501-1,000 employees
Vendor
It provides accessibility and speed for retrieving data.

What is most valuable?

The most valuable features are it's accessibility and speed for retrieving data that I need, along with the ease of use. That's the most important thing: getting the data out. It’s logical, it makes sense, it’s intuitive.

How has it helped my organization?

I'm able to provide analytical data to end users easily, quickly, using a lot of built-in functionalities that the database provides. I don't have to export data to Excel and run a bunch of macros on it in order to get the average column or something like that. The built-ins that they have are helpful.

What needs improvement?

The biggest area for improvement for me is the error messaging. When it returns errors, it gives you a number; here's why I can't insert a character into a number field. One of the most annoying things for me is that it says, for example, "Value too large to insert column" but it doesn't tell you, "Okay you know what you're trying to do. Tell me what you're trying to do so that I can go fix it a lot easier".

So, more information in the error messaging would be nice.

For how long have I used the solution?

I've been using Oracle database for more than 30 years.

I love it. I've been progressing with it ever since. It's nice, it does change a lot every year; there are new features. Oracle's always coming out with new stuff and so it's good; keeps you on your toes, keeps you going to OpenWorld.

What do I think about the stability of the solution?

It is always up. If the database is down, it's more likely something to do with the hardware.

What do I think about the scalability of the solution?

It has scaled well to our needs. We have replication occurring at our office. We use Exadata, and we have clusters. It's replicated across production, dev and two QA instances, so it's nice.

How is customer service and technical support?

I really don't have much knowledge about technical support because I never have to really do that. If something did go wrong with the database, that'd be more of a database administrator's function.

How was the initial setup?

I was not involved in the initial setup. I'm more of an end user of the database.

Which other solutions did I evaluate?

I did not look at any other products before choosing Oracle's database.

What other advice do I have?

It's well worth the investment. It might scare you up front because, yes, there are other, less-expensive options out there for your database, but if you plan on building an enterprise application, it's what you have to do. Spend the money.
I love it; it's the best.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521667 - PeerSpot reviewer
Software Developer at a security firm with 501-1,000 employees
Vendor
The small things that it does compared to the free alternatives are valuable. Its optimization could be improved.

What is most valuable?

I can't think of any specific features that are the most valuable, but all the small things that Oracle does compared to the free alternatives, such as MySQL, are valuable. I do appreciate having that power to do it. Even though 90% percent of the time I don't use those features, it's nice to have them should I need them.

How has it helped my organization?

It actually kind of fractured our organization. Half of us use Oracle for some things and the other half use MySQL for the other. I really don't care; I use both. We use Oracle a lot for authentication. I can't think of anything specific that is all that great about it. I'm not bashing Oracle, I just can't think of anything. I can't think of anything that makes me think, “Oh, we have to have it.”

What needs improvement?

I can't think of any but I know my manager was unhappy with certain features that we use, but we had to pay for those features along with a bunch of other ones that we didn't use. He wanted an option to not bundle a lot of the features. Other than that, I don't know the specifics about what he was talking about.

It's got a lot of good features, but at the same time sometimes certain niche things aren't mentioned. Some things break and I don't know why. Then when I Google it, there are thousands of reasons why they break, so it takes me a while to really pinpoint why. Its optimization could be improved a little bit, but it's good for the most part.

What do I think about the stability of the solution?

It's very stable, we've had no problems with that.

What do I think about the scalability of the solution?

For the most part, as long as you do your research and don't screw up your table structures, I don't have any scalability problems.

How are customer service and technical support?

I haven't used technical support; every issue I've run into I've been able to Google it and figure it out. I haven't had to call in or anything.

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

I believe we used MySQL for a while, it was free and that was the only reason we were using it. It wasn't the most stable, it was a little slow, and it doesn't scale as well, so we decided to go with a more professional solution.

Which other solutions did I evaluate?

I don't know why we chose Oracle, but I know we were debating between Oracle, MongoDB, and PostgreSQL. For whatever reason, I'm not sure why my manager went with Oracle, but we did.

What other advice do I have?

Take cost into consideration and pick whichever really suits your needs. Every single database has its strong and weak points. I wouldn't say it's an end-all, be-all solution, but it just happens to work for us.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user486513 - PeerSpot reviewer
General Manager at Grupo luthe
Vendor
The most valuable feature is security.

Valuable Features

The most valuable feature is security; you do not lose information.

Improvements to My Organization

As a result of using the Oracle Database, users are confident that the information is correct. It doesn't get corrupted, it doesn't get lost, and you can always access it and find it. Before clients used the Database, they used spreadsheets and needed to do a lot of crosschecking between documents to see if operations were valid. After starting with the database and realizing that the information there is always correct, teams start to be more productive, since they don’t have to spend that time crosschecking.

Use of Solution

We've been using it for more than ten years and it really works well.

Stability Issues

It never crashes, so we can have it running for months. It's amazing for the customer because they don't even know it's running. After some time, they forget that there is a database behind them.

Scalability Issues

We have clients that started with one user and now are running up to 200 users. It’s the same version with bigger hardware. It’s amazing the way the database can scale.

Customer Service and Technical Support

Usually response is very good. We have had to escalate issues a few times, but normally it’s fixable.

Initial Setup

It doesn't matter which version you are using or how you deploy it. It will have the same scripts and the same configuration, regardless of size and complexity.

Other Solutions Considered

We have compared it with Microsoft and IBM, and this is a ten out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: ISV
PeerSpot user
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 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.