TrustRadius: an HG Insights company

Oracle Database

Score8.2 out of 10

1,216 Reviews and Ratings

What is Oracle Database?

Oracle Database, currently in edition 23ai, is a converged, multimodel database management system. It is designed to simplify development for AI, microservices, graph, document, spatial, and relational applications.

Read more details.

Categories & Use Cases

Videos

Oracle Database Key Features

Learn about the best (and worst!) features Oracle Database has to offer, as determined by TrustRadius' reviewers.
Based on 1,216 ratings of Oracle Database's features
View all Oracle Database features

Top Performing Features

  • Encryption

    Data is encrypted in-motion and at rest, preventing unauthorized access and security breaches.

    Category average: 8.6

  • Disaster recovery

    Data can be recovered in the event of a disaster.

    Category average: 8.6

  • Database monitoring

    Teams can monitor database usage and performance metrics.

    Category average: 9

Areas for Improvement

  • ACID compliance

    The database complies with ACID (atomicity, consistency, isolation, durability), ensuring transactions are processed reliably.

    Category average: 8.9

  • Multiple datatypes

    The database can store a variety of different datatypes.

    Category average: 8.6

  • Flexible deployment

    The database can be deployed in a variety of environments and operating systems.

    Category average: 8.4

Who Buys & Uses Oracle Database

Oracle Database Reviews

What users are saying about Oracle Database.
View all Oracle Database reviews

Pros

  • Exceptional scalability for high transaction volumes and concurrent operations
  • Robust high availability and disaster recovery features (e.g., Active-Active Clustering)
  • Comprehensive security features for sensitive data environments

Cons

  • Steep learning curve and inherent configuration complexity (e.g., RAC, Data Guard)
  • High cost and complex licensing model compared to competitors
  • Time-consuming and resource-intensive patching and upgrading processes

Most reliable database for your business needs

Incentivized
Verified User
Professional in Information Technology (5001-10,000 employees)

Use Cases and Deployment Scope

We use Oracle Database for various applications, including ERP, application server backends, OLTP, data warehouses, and more. The Oracle database is highly reliable for performance, security and scalability. It provides advanced features like RAC and ASM, which make it useful for banking and high-transaction applications. Adding AI to it makes it very advanced in the AI era.

Pros

  • Highly scalable with the help of RAC cluster
  • No downtime and no data loss with dataguard and DR
  • Low maintenance with Oracle Autonomous Database

Cons

  • Licensing model of Oracle is complex
  • To manage it, highly skilled DBA are required
  • Using Oracle database with other cloud providers is not easy

Return on Investment

  • Database maintenance without any downtime saves a lot in business
  • With Oracle Autonomous database, infrastructure and staffing cost has reduced
  • It has a strong Oracle ecosystem that helps utilise its features sometimes without any further costs.

Usability

Alternatives Considered

Amazon Aurora, Azure SQL Database and MariaDB Platform

Other Software Used

Amazon Aurora, Azure SQL Database, Google Cloud SQL

Powerful and Scalable Database for Enterprise Organization

Incentivized
Verified User
Employee in Corporate (1001-5000 employees)

Use Cases and Deployment Scope

We are using Oracle Database to store data in tables and use it in the application. We are having a lot of application for which we are using Oracle Database as the Foundation to store the data. Also The level of security we accept from it we get that.

Pros

  • Oracle Database is good for High System Availabilty and strong data security.
  • It is also good for the reliable processing of transactions as well as enterprise-level reporting and analytics
  • ACID-Compliant Transaction management and role-based access security

Cons

  • I think the cost should be reduced. Infra cost is so high.
  • High expertise are required for operating of the Applciation
  • Very overwhelming of the software for the begineer i think

Return on Investment

  • It has improved our Operational Efficieny, also it has reduced our manual effort. with faster transaction processing.
  • High Reliability and Reduced Downtime
  • Data Integrity and Accuracy
  • Scalability of the Business Growth
  • Security and Compliance.
  • High Total Cost of Ownership, Dependency of Specialized Resources

Usability

Oracle the most reliable Database solution

Incentivized
Deepjyoti BhowmickView profile
Senior Data Engineer in Information Technology at Accenture (10,001+ employees)

Use Cases and Deployment Scope

Oracle Database is the most reliable database I have ever used because of its wide range of enterprise-grade features, including high scalability, robust security, high availability, and strong performance optimization. Oracle, along with Toad, is a very powerful combo in most companies that maintain an enterprise-grade data warehouse. I still remember, in my first company, the entire large-scale data engineering project was built on top of Oracle PL/SQL. I was the owner of database objects, which consist of more than half a million lines of code. I have written multiple functions for front-end customers to showcase the dashboard, hundreds of procedures, packages to process the OLTP dataset, and inbuilt jobs to load daily OLTP data into the OLAP database.

Pros

  • Secure the dataset from unauthorized users using virtual private database policy enforcement. Thousands of customers used to see their data only in customized dashboards, but the data was sourced from main tables. This helps us to reduce the maintenance burden.
  • Oracle provides concurrent reads using multiversion concurrency control. This helped us to reload incremental data while previous data was still read by users.
  • Oracle database triggers were so supportive during the OLTP reload process. It helped us to maintain referential integrity without the extra headache of reloading dependent tables again and again.
  • The latest Oracle optimizer is at its best level. Companies that have the compliance issue to go to the cloud always prefer to use the Oracle database for its scalability and performance optimization. The default optimizer is working so well that it outperforms other on-premises databases.

Cons

  • Most of the architecture team find it difficult to suggest the Oracle is TCO. Oracle is more costly than peers. So mostly only large and medium organizations can afford this.
  • Badly written queries can increase costs, as they will use excessive system resources. To avoid this, always use the Oracle-recommended method. like CTE, use of partitions, etc.
  • Some of our architects always said there is a vendor lock-in with Oracle. Migration from Oracle to other platforms is costly. Postgres is champion here.

Return on Investment

  • ROI on our previous and current projects is awesome, as all these are big institutions that can absorb the TCO. But not recommended for small enterprises.
  • The Oracle optimizer is the champion for OLAP requirements. I never see performance like this except in horizontally scalable cloud databases. But competitors are doing well now. Oracle should plan it accordingly.
  • Like Oracle performance, security is also unmatched by its peers. That's the reason behind its industry recognition.

Usability

Alternatives Considered

Microsoft SQL Server, PostgreSQL and Teradata Vantage

Other Software Used

Google BigQuery, Google Cloud Storage, Informatica PowerCenter (legacy), Microsoft Visual Studio Code

Oracle Database for Enterprise Applications.

Incentivized
Verified User
Engineer in Information Technology (10,001+ employees)

Use Cases and Deployment Scope

Our requirement was to choose a transactional RDBMS database system that can provide best-in-class High Availability and Disaster recovery, and Zero Downtime for maintenance. Oracle provides a robust, most advanced database backup and recovery (RMAN) feature. Enterprise security features such as data encryption, fine-grained auditing, database vault, etc., were another factor in choosing the Oracle database.

Pros

  • Active-Active Clustering (Oracle RAC).
  • High Availability & Disaster Recovery.
  • Zero-Downtime Maintenance(Rolling upgrade, EBR).
  • Robust Backup and Recovery feature.
  • Performance and Concurrency Architecture.

Cons

  • Oracle database is very complex to use, not beginners friendly.
  • PDB backup and restore still not very efficient in non-cloud environments.
  • Oracle database RAC features are not available with major public cloud providers (Azure, AWS) without using Exadata.

Return on Investment

  • Zero Downtime Application upgrade/deployment, higher possible SLA.
  • Zero or no data loss due to database unavailability. This one was one of the key reasons to migrate to Oracle.
  • Expensive Oracle database licenses drives our service cost higher.

Usability

Other Software Used

Azure SQL Database, PostgreSQL, Oracle Exadata, Oracle Cloud Infrastructure, Oracle Autonomous Transaction Processing, Oracle GoldenGate, Oracle Enterprise Manager

Oracle Review from cybersecurity engineer.

Incentivized
Verified User
Engineer in Engineering (1001-5000 employees)

Use Cases and Deployment Scope

We use several Oracle versions installed on different operating systems, including Windows, Linux, and Unix. We use Oracle DBMS in our cybersecurity product to alert customers to any vulnerabilities or patch requirements in their databases. Our cybersecurity product helps customers address new CVEs on the DBMS by raising an alert to the customers, usually DB Administrators, so that they can secure the Oracle DBMS against live attacks and apply patches to keep their Database secure.

Pros

  • Supports most of the Operating Systems like Unix, Linux and Windows Server.
  • It works well in high load environment under intense parallel transactions setup.
  • Highly reliable DBMS, especially RAC is very much reliable.
  • Well managed and predictable release of security patches.
  • We have highly scaled it from on-prem to a cloud cluster environment for our product.
  • One of the best-performing DBMSs on Linux machines under test delivers high throughput (QPS).

Cons

  • RAC and Data guard are complex and difficult to configure.
  • Manual configuration of Data Guard is difficult, whereas the Active Guard is really smooth.
  • Performance tuning in some aspect needs a good understanding of wait events and the SQL optimizer.

Return on Investment

  • Our product's ability to monitor the Oracle database has generated significant revenue from only a few customers, totaling $1mn.
  • An Oracle account helps analyze the patches and changes going into it, enabling the team to enhance the product and update it more quickly. It reduced the effort by more than 50%.
  • Being a closed-source code DBMS, it is difficult to ascertain the exact exploits of the vulnerability to provide patches to customers and requires reverse engineering.

Usability

Alternatives Considered

MySQL, PostgreSQL, Microsoft SQL Server, MongoDB, MariaDB Platform and Db2

Other Software Used

PostgreSQL, MySQL, Microsoft SQL Server, PyCharm, Eclipse, Oracle Java SE, Google Authenticator, Cisco AnyConnect, Microsoft Visual Studio Code

Oracle Database Alternatives

Products similar to Oracle Database that may also meet your needs.
View all Oracle Database alternatives
MariaDB Platform
CompareLearn more
PostgreSQL
CompareLearn more