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

122 Reviews

Enterprises (1,001+ employees)

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 (Information Technology & Services company, 1001-5000 employees)

Vetted Review

5 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 (Banking company, 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 (Entertainment company, 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 (Computer Software company, 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 (Information Technology and Services, 5001-10,000 employees)

Vetted Review

2 years of experience

View profile

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 (Consumer Services company, 1001-5000 employees)

Vetted Review

19 years of experience

My review of Oracle Database

Rating: 6 out of 10

Incentivized

February 15, 2020

Use Cases and Deployment Scope

A lot of our applications are using Oracle Database as their data store.

Pros

High stability and reliability
A complete set of database features

Cons

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.

Likelihood to Recommend

Oracle Database should be a good fit for any applications who need a database, especially eCommerce use cases. There might be better choices for lightweight applications or applications with very large data sets.

Verified User

Manager in Engineering (Internet company, 10,001+ employees)

Vetted Review

8 years of experience

Looking for scalable and reliability? answer is Oracle!

Rating: 10 out of 10

Incentivized

November 6, 2019

Use Cases and Deployment Scope

It is being used as a customer user-managed database and we use many geo spatial capabilities such as spatial aggregation, intersection, spatial filters, buffering features etc.

Pros

I really like the robust architecture it provides.
It is a very detailed database and is much more scalable than other competitors.
Documentation is great and very detailed.

Cons

Sometimes it gets really complex at writing some large geo spatial queries.
Spatial indexing could be easier.
It requires some level of expertise to operate.

Likelihood to Recommend

Oracle Database is scalable for large and varied applications, robust and reliable for any kind of industry. It may not be useful for small-scale industry as it may get expensive.

Verified User

Engineer in Research & Development (Computer Software company, 1001-5000 employees)

Vetted Review

3 years of experience

Input all your data to get a great birds-eye view of your business operations

Rating: 8 out of 10

Incentivized

November 1, 2019

Use Cases and Deployment Scope

We use Oracle Machine Learning throughout most of our entire organization. Our development, sales, and technical support departments use Oracle extensively. We put everything from support tickets, development requests, and sales data into oracle to give us an overhead view of where we can make improvements to better take care of our customers' needs.

Pros

Throw tons of data at Oracle Machine Learning to get a birds-eye view of your companies data.
The UI design is straightforward and easy to onboard new people.
Constantly added new features and improvements.
It can be tailored to your exact needs with ease.

Cons

Performance can suffer if you input vast amounts of data all at once.
One your initial contract term expires Oracle will hike up your rates and after going back and forth (time-consuming) you get to a reasonable rate.
Like others have stated the formatting can become an issue.

Likelihood to Recommend

Oracle Machine Learning is great for any organization that has vast amounts of data and that requires a birds-eye view of the data in simple reports. This will show you how certain departments can improve and better assist your customers. Oracle can be pricey for small to mid-sized companies compared to other competitors.

Verified User

Executive in Information Technology (Information Technology and Services company, 1001-5000 employees)

Vetted Review

4 years of experience

Why Oracle Database is right for you

Rating: 8 out of 10

Incentivized

October 18, 2019

Use Cases and Deployment Scope

I work for Intuit and here Oracle is used by almost all product teams across all verticles. At our team we primarily use it for recording various application configurations as well as for our data warehouse solution. So we effectively use oracle database products for OLTP and Data warehousing. This helps to make our applications modular as the state is captured constantly within the Oracle DB.

Pros

The query execution and optimization engine are just great in Oracle. A simple "Explain Plan" statement will give a thorough analysis of the query execution plan.
We store huge amount of data in our Oracle database, if we partition well and plan the loads correctly, the database is very fast and provides top performance.

Cons

For us to represent a persona and its relations is more convenient using a graph database rather than a relational DB like Oracle.
Oracle DB is a little more expensive than the other comparable products out there in the market. It will help if the licensing costs are reduced.

Likelihood to Recommend

Oracle DB is very well suited for both OLTP and Dataware solutions. It provided us great performance benefits. It lives by the name to provide ACID properties consistently, and hence, a much-evolved solution. Oracle is not suitable for cases where we need to have a tagging system where for a persona, it will be hard to bring the related things together. It's much easier to do using a graph database.

Verified User

Engineer in Engineering (Financial Services company, 5001-10,000 employees)

Vetted Review

14 years of experience

Loading Reviews List....