Oracle Database

Oracle Database Reviews

Customer Verified
Top Rated

Do you work for this company? Learn how we help vendors

Ratings and Reviews
(1-25 of 180)

Companies can't remove reviews or game the system. Here's why
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • 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
  • 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
Nadyan Pscheidt | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Uses SQL language, which is great and well known for most people
  • Great performance to deal with lots of data
  • Good and vast documentation and community
  • Compared to the most modern databases, it is hard to learn
  • Could be more elastic
  • Expensive licenses
Fahad Khalil | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • PL/SQL support
  • Faster Backup & Recovery Tools
  • High data storage capacity
  • Highly stable
  • Reliable data storage
  • cost is higher comparatively
  • complex in nature
  • modern programing languages not supported
  • learning curve involve
  • support team is not much responsive
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Oracle's High Availability setup is very durable
  • Performance of the database is very good for large databases
  • DR setup is very reliable and can be setup easily
  • ASM Storage management makes life easy in managing the datafiles
  • Licensing cost is very expensive
  • Sometimes getting an expert in Oracle support might be a challenge
Score 3 out of 10
Vetted Review
Verified User
Review Source
  • Stable database platform.
  • Sellable enterprise database platform.
  • Known and trusted vendor.
  • 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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Oracle12c Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. It is one of the oracle finest solution for disaster recovery and data corruption. In this setup - You have one Primary and one or more standby DB in two or more different geographical locations. So, if the database hosted in one location goes down due to planned or unplanned outages, you can easily operate business from remote location database.
  • Oracle12c RAC provides Scale-up architecture. Oracle RAC ensures High Availability. In RAC architecture you have at least two or more physical servers with same configuration connected thru interconnect network. So, if one server goes down, you still have database running from the other(surviving) nodes. In this architecture - You can have appropriate on-demand services. You can easily scale up Servers, CPU, Memory.
  • Oracle12c has amazing Performance Tuning framework. You can very easily fine-tune databases running on Oracle12c. Some of the great features are Oracle ADDM, AWR report, ASH report, SQL report, SQL Plan Management, Tuning Advisor - SQL Tuning Advisor, SQL Access Advisor.
  • Oracle12c has great Back and Recovery solution using Oracle RMAN(Recovery Manager). Without much intervention and work, you can easily restore the database backup whenever and whereever you want.
  • Oracle12c provides great security standards that meet fundamental data security requirements - Data Confidentiality, Data Integrity and Data Availability.
  • Oracle Label Security, Oracle Data Redaction, Oracle Data Masking and subsetting, Transparent data protection, database storage encryption, Unified Auditing, and Oracle fine-grained audit are some great oracle features.
  • In Oracle Data Guard - Oracle standby database is most of the time passive and nothing happening on it other than applying the log. Even in Oracle Active Data Guard configuration - You can not do more than running the business SQL query on the standby. Oracle must come up with solution such that standby database can also be fully utilized as a full operational database.
  • Oracle should improve on Oracle internal locking mechanism, latch, and data concurrency. I have seen databases which runs fine with less number of ACTIVE user sessions. When ACTIVE user sessions are increased in the same database - db performance is deteriorated proportionately. If the database kernel has designed correctly, there won't be any db performance issue regardless of any number of user connections/sessions.
  • In current time - DB growth is very common, today your db size is 20GB, It may be 500GB at the end of the year, so on and so on. With respect to db size increase, Oracle must improve on RMAN(Recovery Manager) backup tool. The expectation is that faster backup and restore as and when needed. There is always a debate that - Please don't run RMAN backup,data pump export backup, and gather stats job during business peak hours as it will impact DB performance. Oracle database should have designed in such that Administrative jobs like Backup, data pump export and DB gather stats should not have db performance impact anytime, at any cost. Even Oracle claims that Oracle DBRM (Database Resource Manager) is solution to this problem, but, in actual, it doesn't address the problem in much better way.
Arthur Zubarev | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • 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.
  • 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.
Panav Beri | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Easy deployment across multiple servers.
  • Easy UI to manage large databases.
  • Good documentation for troubleshooting.
  • Highly scalable based on the data load.
  • Performance is affected when data size increases over time.
  • No effective 24/7 support from Oracle.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Best thing about it is that it supports PL/SQL which is helpful in writing complex quarries easily.
  • Its storage capacity , backup and recovery features make it the best database storage tool available.
  • Other thing I like about this software is its interface is so good.
  • Nothing much I could think of but ya it is very tough to understand it's functions and it's use.
  • It is quite expensive as well.
April 29, 2021

Review

Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Multitenant architecture has reduced the DB foot print and maintenance.
  • Refreshing test database from production has become affordable and manageable.
  • Restoring and recovering tables with Rman has become easy with 12c.
  • Like MySQL Oracle also should provide a way to manage both unstructured and structured Data in same DB.
  • More free training through OTN (self study videos) about 12c performance and how to adapt to it.
  • Plan stability without adapting to use SPM when upgrading to newer versions. SPM has caused problems like taking up too much memory in the DB server when implementing it to overcome the shortcomings of upgrade with optimizer behavior altering the performance. In a way a more adaptable approach would be beneficial for DBAs for upgrade not compromising performance which I think is one of the biggest challenges upgrading .
Score 6 out of 10
Vetted Review
Verified User
Review Source
  • High stability and reliability
  • A complete set of database features
  • Performance is sub-optimal when data size is large.
  • Non-trivial effort to setup. We have to build some automation so developers can save some time to set it up on their local machines.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Pluggable databases really help with consolidation.
  • Restore a table or table partition easily using RMAN.
  • Online migration of a Table Partition or Sub Partition.
  • License on virtual infrastructure.
  • Technical support needs to improve.
  • Data Guard setup needs to simplify and troubleshooting is still too complex.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Oracle Database does security and compliance very well out of the box without the need for much configuration.
  • It works very well across on-prem and cloud deployments where we want part of the database in-house (due to compliance reasons) while the rest can be in the public cloud.
  • It is also very good in scaling to large datasets and performance numbers ( time to run a SQL query) are much better than DB2, Microsoft SQL Server etc.
  • Pricing can be improved to make it much more competitive with other RDBMS options in the space
  • Best practices documents and deployment scenarios for running Oracle Database on non-Oracle cloud platforms would be helpful (for example Oracle Database on Google Cloud and Microsoft Azure).
  • Certainly room for better integrated and automated SQL tuning.
December 05, 2019

THE Database and RDBMS

Balázs Kiss | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • "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.
  • The licences around using the DB are quite pricey. But hey, for a high quality, you cannot expect a freeware software...
Score 2 out of 10
Vetted Review
Verified User
Review Source
  • 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.
  • 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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Highly performant/reliable and good technical support
  • ACID -- Supports ACID transactions
  • Non-structured Data -- XML, hard to use
  • High Availability -- Real application clusters are available but it is difficult to set up and maintain
Eduin Zuloaga | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Replication using GoldenGate. We replicate almost 500k transactions per day between Brasil and México and it works perfectly.
  • Velocity, quality, and support.
  • Relational database to handle financial transaction systems using OLTP when customers pay for fuel.
  • Parallel execution to apply multiple CPU and I/O resources to the execution of a single database operation.
  • It's hard to find Oracle specialists.
  • Oracle specialists are expensive.
November 20, 2019

Immensely complicated

Zhann Goloborodko | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source
  • The database itself rarely goes down.
  • Bringing up new Oracle instances is relatively painless.
  • With the help of data pumps, moving data from place to place is a breeze.
  • If you pay for their support, while they aren't the speediest, they are incredibly well informed and are an amazing help.
  • Immensely complicated. Of all the databases we use, this one has by far the most moving parts.
  • It is highly recommended to have a dedicated Oracle DBA on staff if you want your databases healthy. We have no such difficulty with Sybase, SQL Server or SAP IQ.
  • While the Support Team is incredibly informative, they are often very slow to respond and are often unwilling to answer questions that don't directly solve the problem at hand.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • I believe other users have reviewed the pros already. I am addressing only the Cons of 12c R2.
  • SYSAUX tablespace grows rapidly. I didn't need to add space to SYSAUX last a few years in 11g. But after upgrading to 12c R2 12.2.0.1, SYSAUX grows daily, and I have to add space to SYSAUX regularly, about every 2 weeks. I am currently opening an Oracle SR and working with Oracle Support on this issue.
  • Some of our small databases only use about 5GB excluding SYSAUX. But SYSAUX uses 5GB alone!
  • Almost all universities (if not all) in the USA have been using Banner application. But Banner app users fail to log on 12c Release 2 databases after upgrading to 12c R2 from 11g because of an Oracle Bug related to password-protected profile. I applied an interim bug to work around this issue. However, since Oct 2018, the PSU patching will not work. I must rollback the interim bug, and then patch the PSU, and then apply the interim patch again to resolve the Oracle bug. I asked Oracle to include the interim in the PSU in Oct 2018. But up to PSU Jul 2019, Oracle didn't implement it yet!
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • First of all DB needs to be upgraded to Oracle 12c for support prospective from Oracle.
  • Oracle 12 has some great features with respect to auditing.
  • Keeping the data with respect to hot and cold rows is also a great features helping in managing data well.
  • It had installation issues where it needed to have a patch applied before installation could begin. Downloaded software should have been tested before providing it to the user.
  • Oracle 12.1 was not very stable so we had to migrate it to 12.2 after some time.
September 18, 2019

Oracle and VSE Corp

Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Performance - We have several ERP systems all running on various platforms. By far the best performance in terms of consistency being up and available is our Oracle platform. To put into scale, out of all three platforms, since I have been employed, Oracle has not been down once, while the other two have been down multiple times, to the point that my attendance at OOW2019 is focused on migration from other platforms to Oracle.
  • Security - The matter of security is huge. One of the biggest points in choosing an Oracle database and appliance over anything else is the security it provides in counter to anything else on the market.
  • Training - While there is an enormous amount of training available, there are still gaps in terms of availability for classroom-style learning. I have found it more effective to be in a classroom setting where one is held accountable at that moment in time as opposed to self-paced (pure personal preference).
  • Cost - While we love the databases and appliances, the cost of maintaining is becoming an issue when competitors are coming in at such a lower point. Pushing this to a more profits oriented C-level makes justification difficult at times.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • An automated case management system has eliminated our duplication of effort in most instances.
  • Having electronic work papers has allowed us to access other case files so we have access to more data saving us time and stopping the need for duplicate request.
  • Our compliance cases are very task-oriented and the out of the box flow works very well with these cases.
  • From the audit perspective, we have had to customize a lot to meet our electronic work paper needs.
  • We have quite a few open Oracle service requests that have been outstanding for years.
  • The history around the completed task is lacking out of the box.

What is Oracle Database?

The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed workloads through any deployment strategy, on premises or in the cloud.

For more information visit https://www.oracle.com/database

Oracle Database Video

What is Oracle Database?

Oracle Database Competitors

Oracle Database Pricing

Oracle Database Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

What is Oracle Database?

The Oracle Database, now in edition 19c, is presented by the vendor as an industry leading database that delivers leading-edge innovations, including machine learning to enable self-driving data management. An enterprise, database cloud service, it is designed to support mixed workloads through any deployment strategy, on premises or in the cloud.

What is Oracle Database's best feature?

Reviewers rate Support Rating highest, with a score of 10.

Who uses Oracle Database?

The most common users of Oracle Database are from Enterprises and the Information Technology & Services industry.