Oracle Database Reviews & Insights

Score7.9 out of 10

1,185 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle Database are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

High Security Level: Users consistently praise the high level of security in Oracle Database, ensuring robust protection against unauthorized access attempts and safeguarding sensitive data effectively with advanced encryption and authentication features.

Fast Performance with In-Memory Feature: Customers appreciate the rapid performance and enhanced query speed provided by Oracle's in-memory feature, optimizing operations for large and complex tables while improving overall system efficiency and responsiveness to user queries.

Reliable High Availability Setup: Reviewers highlight the durability and exceptional performance of Oracle's High Availability setup, emphasizing its reliability for maintaining seamless database operations even under intensive workloads, offering a solid foundation for critical business functions.

Oracle Database Reviews

51 Reviews

Mid-sized Companies (51-1,000 employees)

Oracle Database: The Best in Business & Totally Worth

Rating: 9 out of 10

Incentivized

January 3, 2024

Use Cases and Deployment Scope

We are a service support company and I am a certified Database Admin. We have different customers using Oracle databases and we maintain those databases. We do maintenance, monitoring, upgrade, and even migration of databases.

Pros

In memory feature - very fast. Earlier queries used to run in fetching data used to take time now it is very fast. We can even select which table should be used in the memory feature. So complex and big tables are utilized properly.
Restore and Point of Time Recovery - In my entire career of 10 years, Oracle Database has been the most consistent and reliable database. The RMAN backup concept is the best example. If any disaster happens in another database, there is a chance of loss of data or getting corrupted but Oracle is best.

Cons

Oracle Database restoration and recovery is complex. RMAN backup recovery has quite a lot of steps and is complex. In other databases, it is very much simplified.
Oracle user extend validity - this is tricky as users are assigned to profiles and if you want to extend the validity of a particular user, it becomes difficult. That is where it can be improved.

Likelihood to Recommend

It is suited for Linux as Linux machines are generally not rebooted for years. We have seen other databases with memory leak issues or Windows system resource utilization becomes high and we need to regularly reboot machines whereas in Linux, Linux doesn't have those issues. With the Oracle Database combination, we have seen some critical production servers that do not need to get rebooted for years and still work well without any issues, which is amazing.

Verified User

Consultant in Information Technology (Computer Software company, 201-500 employees)

Vetted Review

8 years of experience

Stable but Expensive and Tough to Use Enterprise Database Platform

Rating: 3 out of 10

Incentivized

April 10, 2021

Use Cases and Deployment Scope

Oracle Database is our organization's primary database server. Our main line of business application uses it exclusively to store data making it mandatory across the organization. It provides a stable and scalable relational database platform but a high custom with extremely inflexible and frustrating licensing terms.

Pros

Stable database platform.
Sellable enterprise database platform.
Known and trusted vendor.

Cons

Cost: platform is expensive
Virtualization support: Licensing model makes virtualization costly.
Difficult to work with: Oracle is one of the most difficult vendors to work with.

Likelihood to Recommend

Oracle provides a scalable and stable enterprise relational database platform. Oracle understands stability, assuming you provide capable and stable hardware Oracle will stay running. But it's too complex to manage and Oracle's licensing terms make virtualization either complex or expensive. Unless your application requires it, find another database platform.

Verified User

Engineer in Information Technology (Information Technology & Services company, 201-500 employees)

Vetted Review

15 years of experience

My Succinct Oracle Database Satisfaction Recap

Rating: 8 out of 10

Incentivized

April 8, 2021

Use Cases and Deployment Scope

The Oracle Database or rather a cluster of Oracle Databases is used for both an OLTP and data warehousing data storage and processing purposes across various departments. Oracle Database is a very mature and versatile platform that allows running almost any business entirely using only the database. At Parsons Smart Vehicles Solutions, we rely on Oracle for conducting the critical line of business. The database's unique resilience capabilities, programmability, and mature tooling allow for rapid software development while maintaining high quality. Oracle is widely supported by vendors' databases, which makes integration easier.

Pros

Automated database objects validation: correctness of views, packages, triggers, and everything is built-in. This minimizes the risk of using malfunctioned software and makes it easy to fix broken code.
Rich programmability model: the database supports not only the very rich SQL but also PLSQL, Java and it has very good command-line tools that make change management easy and efficient.
Excellent for data warehousing with its support for automatic materialized views management, table sequences, data types, updatable cursors, advanced SQL as Windowing Functions, built-in upsert semantics via the Merge SQL.

Cons

The memory demand and management makes it impossible to run it in a container.
It is hard to perform local unit testing with Oracle even using the personal edition (aggressive all the available memory grab for itself).
Lack of built in database migrations (e.g. as Flyway).
The need to install the Oracle client in addition to its drivers.
The cost of running it, especially in the Cloud.
Comes with very spartan community grade client/management tools whereas the commercial offerings tend to demand a premium price.

Likelihood to Recommend

I would say that if the business generates considerable revenue and must rely on a world-class feature-rich database engine, not in the Cloud, to do more than simple OLTP then Oracle Database is a go-to offering. The other factor is that Oracle talent is likely available in abundance. Having one backed by Oracle is a long-term advantageous strategy.

Arthur Zubarev

Senior Data Platform Consultant in Information Technology at Parsons Corporation (Information Technology & Services, 51-200 employees)

Vetted Review

5 years of experience

View profile

Oracle Database Cloud Service to reduce the efforts and cost

Rating: 9 out of 10

Incentivized

February 13, 2021

Use Cases and Deployment Scope

The Oracle Database Cloud is being used across our organization. It is being used for our cloud-based enterprise applications for storage and management of huge data on cloud. The benefits of using it includes but are not limited to the following:

No hardware required.
No installation required.
Minimizes the cost of operation.
Minimizes the cost of maintenance.
Fasten data processing speed.
Enhanced integration and connectivity with our application.
Enhanced application performance.
Increased reliability in terms of data security.
Scalable to meet the increase in requirements.
IT staff have more time available to spend on other useful things.
The speed of queries and searching is improved.

Pros

Eliminates the requirement of hardware and installation.
Minimizes the cost of operation and maintenance.
Scalable to meet the increase in requirements.
Enhances integrity, connectivity and performance of our applications.
Reliable in terms of data security.
Improved speed of querying and searching.

Cons

Prices are higher comparatively.
User interface seeks moderation to be attractive.
Customer Support is very slow.
Some modern programming languages are not supported.

Likelihood to Recommend

The Oracle Database Cloud Service is best suited in many scenarios including but not limited to the following:

To reduce the cost of hardware purchase, setup, and maintenance.
To reduce the cost of operation and maintenance of a database.
To enhance the speed of data processing and transfers.
To improve the integrity, connectivity, and performance of an application.
To increase reliability in terms of data security and scalability.
To increase the speed of querying and searching.

Abdul Wahab Khan

Project Manager in Professional Services at Softronic Systems (Pvt) Limited (Computer Software, 51-200 employees)

Vetted Review

1 year of experience

View profile

Oracle databases in my day to day work

Rating: 8 out of 10

Incentivized

January 13, 2020

Use Cases and Deployment Scope

Oracle is the database that stores millions of transactional data generated by the different applications that support the core of the business (health services), ensuring that integration between them is possible. Additionally, it is used to generate and analyze information to respond to surveillance and control entities.

Pros

Guarantees the reliability and availability of data when required
Supports the processing of large blocks of information

Cons

Licensing prices in additional packages
Timely response by the support team when required

Likelihood to Recommend

The Oracle database is suitable for storing large volumes of information; I have demonstrated its strength in writing data. Enabling and acquiring additional package licenses is very powerful guaranteeing the security and traceability of the information. The Oracle database is less appropriate for processing large volumes of data distributed across multiple instances.

Verified User

Team Lead in Information Technology (Hospital & Health Care company, 501-1000 employees)

Vetted Review

4 years of experience

Oracle did not live up to our expectations

Rating: 2 out of 10

Incentivized

December 14, 2019

Use Cases and Deployment Scope

Oracle was chosen as the database to support an older ERP-type application with the actions of the vendor of the app forcing our hand to use Oracle. So it was to replace a different database. The project was to convert not only the data but also tons of code in the form of stored procedures and scripts. The vendor said it shouldn't be hard. Hah!

Pros

Flashback! With Oracle, you can flashback an entire database or just some tables to the state they were in at a certain point in time. Or you can even write a query that uses the data from a point in time. Very valuable for testing and maybe recovering from an error you just discovered you'd made! Of course, there is overhead for this feature and you need to dedicate a lot of disk space for it and you can't go back forever, but there are times where this is so handy and much quicker than restoring a backup (especially an Oracle backup in multi-tenant architecture).
There are all sorts of features for limiting the resource usage of users.

Cons

Oracle GUI tools for the developer and the DBA are lacking in polish and user-friendliness. Error handling is poor. You need to restart the tool (esp SQL Developer) at least once a day to correct non-sensical results. Enterprise Manager is known to be powerful but hard to learn/hard to use. Instead much is done on the command line which means you need to memorize commands like in the ancient days of MS-DOS. There are many GUI tools that Oracle produces each with a different idea of how user interfaces should be set up. An awful mishmash. They need to learn to write software from the user;'s point of view.
Oracle support is not helpful. Oracle is the world's most difficult database to use (especially for the DBA) but the support is lacking - not a winning business model. Slow responses. The first line of support usually knew less than I did because I had plumbed the depths of the Internet before calling them. The support folk were usually from India based on their names. The support process asks if you'd rather get help via email or a phone call. I'd usually say phone call but due to the time difference, they rarely would oblige. I hear that there are certain times of day that if you put in your support request then, you are more likely to get US-based help. It was so common to wait forever for help so you'd have to escalate it to the next level. The next level folks were more likely to know something. See the next point re: support.

Likelihood to Recommend

If you are a small to medium-sized business, you shouldn't consider Oracle at all. You need highly-skilled and highly paid sharp developers and DBA's to manage the beast. And there are much better alternatives for you - from MySQL to SQL Server - SO much easier to use. Things that would take me 5 minutes to do in SQL Server would take hours or days in Oracle. Even our paid consultants would have trouble making the software do what it was supposed to do. And there isn't nearly as much helpful info on the web for Oracle as there is for SQL Server. I'd always thought well of SQL Server prior to using Oracle, but now I am even more appreciative of its ease of use. If you are with a large enterprise, it could be an option if it does something that no other RDBMS does and you really need that. But such cases I'd bet are few and far between. Other databases, like MS SQL, can run large workloads with good performance. Do you really need to buy the most difficult to use the software?

Verified User

Consultant in Information Technology (Non-Profit Organization Management company, 51-200 employees)

Vetted Review

2 years of experience

THE Database and RDBMS

Rating: 10 out of 10

Incentivized

December 5, 2019

Use Cases and Deployment Scope

The most robust, stable, and biggest RDBMS I have ever encountered. As the biggest member on the market, and one of the leaders in IT industry, Oracle database is still and probably will be the standard database that everybody would want to use. The enormous knowledge and science and effort and functionality that is put into this product is insane - but for a price.

Pros

"THE" Database, period. No more robust, secure, and stable relational database exists.
Support from a wide range of professionals all over the world. Their academies and documentation is well above the average.
Absolute best reliability in the market: ACID was kinda invented by those guys.
Thousands of supporting tools, technologies, etc.
They moved into the cloud! and are now a quite strong competitor vs. Amazon Web Cloud.

Cons

The licences around using the DB are quite pricey. But hey, for a high quality, you cannot expect a freeware software...

Likelihood to Recommend

Although this database is massive, it's the best selection for quite a lot of things. From the automatic query optimization to the physical table lookup, every single aspect is a product of years of innovation. Most of the tools/techniques used today in other DBs were first was implemented in this. Oracle Database can fulfill nearly every database requirement a small, a typical, or a giga-company needs. With the right professionals, this tool can run countries!

Balázs Kiss

Software Developer in Engineering at Webvalto Ltd. (Banking, 51-200 employees)

Vetted Review

3 years of experience

View profile

Non-stop traffic with Oracle Database

Rating: 9 out of 10

Incentivized

December 4, 2019

Use Cases and Deployment Scope

We use Oracle 12c databases to store information from many of the critical modules of our MLFF (Multi Lane Free Flow) tolling solutions. Oracle Database 12c can handle variable workloads, maintaining throughput at peak moments. Our solutions utilize many different technologies, but rely on Oracle Database as a key component.

Pros

Oracle Database 12c has the ability to scale to support intensive workloads.
PL/SQL provides an efficient way to develop data-intensive processes that are able to interact with data without transferring it to an app server
Partitioning, Compression and Encryption are some of the optional features that enhance performance, reduce costs and secure the information stored in Oracle Database 12c

Cons

New (actually it is more than five years old) multi-tenant architecture is not as straightforward as SQL Server, but it has been enhanced in Oracle 12c Release 2 and later 18c and 19c.
Many features require additional licensing (either as options or as packs) that increase the total cost

Likelihood to Recommend

I believe that Oracle Database can be used almost on any scenario, starting with small department solutions to actually any enterprise level system. It includes many features that allow a single database to work as an OLTP and Data Warehouse at the same time, reducing hardware requirements and the need to implement ETL or integration solutions between OLTP and DW.

Lisandro Fernigrini

Master Software Developer (Database Architect) in Information Technology at Neoris (Information Technology and Services, 501-1000 employees)

Vetted Review

3 years of experience

View profile

Oracle Database 12c Review

Rating: 8 out of 10

Incentivized

November 27, 2019

Use Cases and Deployment Scope

Oracle Database 12c is being used across my organization. It is our core database for almost all software.

Pros

It works in different operative systems.
You can manage it with a web console.
You can have different Oracle tools to complement it.

Cons

Not many Oracle Database administrators in Columbia.
It is not easy to manage.
The licenses are expensive.

Likelihood to Recommend

Database 12c is a good, stable choice for large amounts of data. However, the license is expensive, and you need an Oracle Database expert on your team.

Verified User

Director in Information Technology (Health, Wellness and Fitness company, 501-1000 employees)

Vetted Review

1 year of experience

Solid and reliable ACID complaint transactional database by oracle!

Rating: 8 out of 10

Incentivized

November 25, 2019

Use Cases and Deployment Scope

Oracle database 12c is being used as the main transactional database by my organization. It's primarily managed by the database administration and batch data processing teams. The business problems it addresses is the need to reliably and consistently store data that requires complete consistency and has a lot of capability to be queried in the future for analytics. The Oracle database does transactions the best with it's ACID compliant framework that gives us confidence that data will be stored reliably.

Pros

ACID transactions
Reliability
Scalability
Top notch documentation
Data storage and administration

Cons

Error code explanations
Pricing for smaller organizations
Innovation to meeting newer database standards
NoSQL could be preferable

Likelihood to Recommend

Oracle Database 12c is a solid, relational ACID compliant database that can be used even for the heaviest workloads to store data in a way that ensures integrity and reliability. It's less appropriate in situations where you have nonrelational data and could use a document based database as storage method. Oracle is still primarily relational data storage.

Verified User

Consultant in Information Technology (Internet company, 51-200 employees)

Vetted Review

2 years of experience

Loading Reviews List....

Oracle did not live up to our expectations

Rating: 2 out of 10

Incentivized

December 14, 2019

Use Cases and Deployment Scope

Pros

Flashback! With Oracle, you can flashback an entire database or just some tables to the state they were in at a certain point in time. Or you can even write a query that uses the data from a point in time. Very valuable for testing and maybe recovering from an error you just discovered you'd made! Of course, there is overhead for this feature and you need to dedicate a lot of disk space for it and you can't go back forever, but there are times where this is so handy and much quicker than restoring a backup (especially an Oracle backup in multi-tenant architecture).
There are all sorts of features for limiting the resource usage of users.

Cons

Oracle GUI tools for the developer and the DBA are lacking in polish and user-friendliness. Error handling is poor. You need to restart the tool (esp SQL Developer) at least once a day to correct non-sensical results. Enterprise Manager is known to be powerful but hard to learn/hard to use. Instead much is done on the command line which means you need to memorize commands like in the ancient days of MS-DOS. There are many GUI tools that Oracle produces each with a different idea of how user interfaces should be set up. An awful mishmash. They need to learn to write software from the user;'s point of view.
Oracle support is not helpful. Oracle is the world's most difficult database to use (especially for the DBA) but the support is lacking - not a winning business model. Slow responses. The first line of support usually knew less than I did because I had plumbed the depths of the Internet before calling them. The support folk were usually from India based on their names. The support process asks if you'd rather get help via email or a phone call. I'd usually say phone call but due to the time difference, they rarely would oblige. I hear that there are certain times of day that if you put in your support request then, you are more likely to get US-based help. It was so common to wait forever for help so you'd have to escalate it to the next level. The next level folks were more likely to know something. See the next point re: support.

Likelihood to Recommend

Verified User

Consultant in Information Technology (Non-Profit Organization Management company, 51-200 employees)

Vetted Review

2 years of experience