There are several valuable features that we've found in our experience, including ACID compliance, strong backup and recovery features, smart cost optimizer, very good stability, performance, and it includes disaster recovery solutions.
Oracle Database is renowned for its reliability, scalability, and performance, delivering high availability and security. It integrates seamlessly with other systems, providing exceptional data protection and backup, suitable for managing multiple applications and supporting large datasets.



| Author info | Rating | Review Summary |
|---|---|---|
| Database Administration Principal at a tech services company with 501-1,000 employees | 5.0 | I find Oracle a technically superior RDBMS, highly reliable for mission-critical systems with great stability and performance. However, high licensing costs, limited Standard edition features, and poor technical support are significant drawbacks. |
There are several valuable features that we've found in our experience, including ACID compliance, strong backup and recovery features, smart cost optimizer, very good stability, performance, and it includes disaster recovery solutions.
The company I'm currently working for is an ISV that develops applications for the healthcare system, where High Availability is the main concern. Oracle puts the database layer at the highest level of reliability. As a plus, the smart optimizer can compensate for a poorly written SQL, giving good response times.
The biggest improvements are mainly high license costs and the unavailability of Enterprise edition options on the Standard edition. For example, on the Standard edition, you cannot buy transparent data encryption, needing the Enterprise edition to access that option (which has to be paid for separately). Official certification for VMware environments would also be an improvement.
I've used it since 2001, mainly on OLTP systems, as it is well-suited as an OLAP solution.
We have had no issues with the deployment.
All software has bugs and Oracle database is no exception. Oracle's RDBMS offers a high level of stability, but the increasing complexity (added functionalities and options) is in some way increasing the risk of hitting a bug.
We have had no issues scaling it for our needs.
The level of technical support is quite low compared to the software level. It's hard to find a skilled specialist and response times are high. On the other side, except for really heavy load systems, it's quite rare to have to engage support.
The Oracle setup process has been simplified over the years, but it's still a complex task, at least when it comes to High Availability/disaster recovery solutions (RAC, DataGuard).
I was an Oracle on-site consultant so it is one of my major responsibilities to set up the Oracle Database according to best practices. Always start from RPO/RTO constraints to design the solution and read the Oracle manuals -- they’re wide but very well written.
I would advise that you carefully evaluate the compatibility of the software solution with Oracle Standard Editions which are way less expensive. Also, take a look to the new Standard Edition licensing model (called Standard Edition 2).
I'm currently studying PostgreSQL, which is an interesting RDBMS solution and it's open source (similar to BSD license).
From a technical perspective, it is the best RDBMS solution on the market so far. For mission critical solutions, I suggest engaging a senior Oracle database consultant to do the job. An experienced DBA can configure the system to leverage the full potential of the RDBMS both on the performance side and on the availability (backups, BC, DR).
| Product | Mindshare (%) |
|---|---|
| Oracle Database | 10.3% |
| SQL Server | 10.2% |
| IBM Db2 Database | 6.5% |
| Other | 73.0% |
| Company Size | Count |
|---|---|
| Small Business | 68 |
| Midsize Enterprise | 53 |
| Large Enterprise | 137 |
| Company Size | Count |
|---|---|
| Small Business | 769 |
| Midsize Enterprise | 301 |
| Large Enterprise | 603 |
Oracle Database offers a powerful platform for managing data across industries such as finance, manufacturing, and agriculture. It is particularly beneficial for ERP systems, data warehouses, and transactional processing. Users can harness advanced security measures, automation, and integration capabilities, though high pricing and complex licensing can deter smaller enterprises. The database's flexible yet intricate setup process requires advanced skills, while limited integration with other databases and cloud platforms can be a drawback. User interface improvements, along with enhancements in query optimization and support services, are areas for potential development.
What are Oracle Database's key features?Industries like finance, manufacturing, and agriculture utilize Oracle Database for its ability to handle extensive transactions and data analyses. It's essential for ERP systems, supporting CRM, e-commerce, and healthcare applications with its robust infrastructure and disaster recovery options. Despite its challenges in pricing and complexity, it remains a top choice for organizations requiring reliable and high-performing databases.
Oracle Database was previously known as Oracle 12c, RDBMS.
Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A