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.

Reviews

191 Reviews

Best Relational Database- Oracle Database

Rating: 9 out of 10

Incentivized

January 6, 2024

Use Cases and Deployment Scope

I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and data is stored in the form of tables. We usually retrieve the data using the SQL queries. The oracle database helps me to easily retrieve the complex data. By implementing permission and altering user activities, we can simply prohibit unauthorized access and provide separate access to users.

Pros

Easily retrieve complex data using SQL queries
Provides high level of security from unauthorized access.
Data can be easily recoverable it it is deleted by mistake
Installing in windows machine is easy

Cons

Price is one of the reason, as its licensing cost is expensive. Rest is good

Likelihood to Recommend

According to me, Oracle database can be used by multiple applications. So in my case I have used for two applications- EMR and cognitive search, which makes my life easier.
I can say it is less appropriate in some cases when it required high maintenance. Also its licensing cost is too expensive.

Verified User

Team Lead in Information Technology (1001-5000 employees)

Vetted Review

5 years of experience

Oracle Database: The Best in Business & Totally Worth

Rating: 9 out of 10

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 (201-500 employees)

Vetted Review

8 years of experience

Oracle Database - Harnessing the Power of Data

Rating: 9 out of 10

Incentivized

January 3, 2024

Use Cases and Deployment Scope

Oracle Database is being used in the compnay as SOR database for many business products. I am an active user or it in Banking and Mortgage Businesses.

Pros

The Native PL/SQL Language is very simple to learn and use. Stored Procedures created are easy to maintain as well.
Data Recovery Setup is very effective and easy to use

Cons

Database Administrative tasks impact the DB performance
No support for Unstructured Data

Likelihood to Recommend

Oracle Database is best suited for multi-tenant architecture where more than one database is being used simultaneously...its very well supported in such scenarios.

Not recommended for cases where Un-Structured data is the main source of the business.

Verified User

Analyst in Information Technology (5001-10,000 employees)

Vetted Review

9 years of experience

Oracle Database is still King of databases (minus the licensing cost ;-) )

Rating: 9 out of 10

Incentivized

June 23, 2021

Use Cases and Deployment Scope

Oracle [Database] is used by [a] couple of departments to maintain Animation assets and for couple of applications in the Animation movie making workflow.

Pros

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

Cons

Licensing cost is very expensive
Sometimes getting an expert in Oracle support might be a challenge

Likelihood to Recommend

I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.

Verified User

Administrator in Information Technology (1001-5000 employees)

Vetted Review

15 years of experience

Oracle Database a tool that can sotre

Rating: 9 out of 10

Incentivized

April 12, 2021

Use Cases and Deployment Scope

Oracle Database software has been used by our organization form past few years, mainly it is used by our Information Technology department for backup of data and recovery.
The main business problems it addresses are database conversation, backups and the best part is that it supports multiple programming languages as well. We can save huge amount of data without any instability.

Pros

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.

Cons

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.

Likelihood to Recommend

Oracle Database is one of the best database storage and management software according to me as it has a huge storage capacity. Other than that the reason behind its good performance is that it supports PL/SQL which helps user to write complex quarries. Last but not least it allows us to backup data and we can easily recover the data anytime.

Verified User

Employee in Quality Assurance (1001-5000 employees)

Vetted Review

1 year of experience

Dump the data and see the magic!!!

Rating: 8 out of 10

Incentivized

April 11, 2021

Use Cases and Deployment Scope

Oracle Machine learning (formerly OAA) addresses a wide range of problems related to big data and data analytics. It helps the analytics team to analyze huge chunks of raw data obtained for research purposes. This data can come from open source, or medical equipment companies, and more.

Pros

Analyzing heaps of data dumped into the machine learning tool.
Giving the researcher an insight on which direction to proceed in order to get the desired results.
Can help perform a functional analysis before doing a deep dive.

Cons

Pricing for tools integrations is [a] big negative aspect.
Formatting is not as user friendly as it looks.
I encountered issues with loading large amounts of data for research purposes.

Likelihood to Recommend

One of the best features of Oracle Machine Learning is the ability to be able to use it in python environment. The OML4py is amazing when it comes to deployments (uses REST API) and the manipulation of data and tables in the environment works as a charm. I have personally used the feature selection whilst performing a principle component analysis for one of the research papers and OML4py was spot on.

Meena B

Information Technology Project Manager in Information Technology at Binghamton University (5001-10,000 employees)

Vetted Review

2 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 (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 (51-200 employees)

Vetted Review

5 years of experience

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 (51-200 employees)

Vetted Review

1 year of experience

Excellent experience using Oracle products over the past 18+ years.

Rating: 10 out of 10

Incentivized

February 18, 2020

Use Cases and Deployment Scope

We use Oracle Database for storing relational data for our OLTP/warehouse DBs. We also use it as a high availability solution (Data Guard). It is being used enterprise-wide. It helps to store, retrieve, and run analytics on data. The Dataguard also helps offload the queries from primary and helps with performance.

Pros

Highly performant/reliable and good technical support
ACID -- Supports ACID transactions

Cons

Non-structured Data -- XML, hard to use
High Availability -- Real application clusters are available but it is difficult to set up and maintain

Likelihood to Recommend

It is highly performant and guarantees data consistency based on ACID compliance. Oracle Active Data Guard allows us to open the standby database for read operations. With Oracle 19c , Oracle also allows to do DML redirection on standby DB which can help with some reports that need temporary tables.
Using XML/non-structured data is not easy and I have noticed performance issues when the XML becomes deeply nested.

Verified User

Administrator in Information Technology (1001-5000 employees)

Vetted Review

19 years of experience

Loading Reviews List....

My Succinct Oracle Database Satisfaction Recap

Rating: 8 out of 10

Incentivized

April 8, 2021

Use Cases and Deployment Scope

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

Arthur Zubarev

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

Vetted Review

5 years of experience