Oracle Database Professional, Scientific, and Technical Services 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

34 Reviews

Professional, Scientific, and Technical ServicesLaw Practice1Information Technology & Services27Marketing & Advertising1Research2Computer & Network Security1Graphic Design1Human Resources1

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

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

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

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

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

#1 Database on the market!

Rating: 10 out of 10

Incentivized

September 30, 2019

Use Cases and Deployment Scope

We have over 40 Applications running on Oracle Database. Oracle Database is used by the entire organization in dev, test, staging, training and production environments. I can't, unfortunately, go into details of the business problems it addresses.

Pros

Oracle Database Security - #1 on market - Database Vault, Transparent-Data-Encryption (TDE), Audit Vault, Label Security, User Security, Fine Grain Auditing, SQL Injection, Network Encryption, Virtual Private Database (VPD), and etc.
RMAN backup/restore.

Cons

Oracle CPU patching - A nightmare to manually deploy it to every single database every quarter.
In OEM, there are limited functionalities for SQL server.
SID limited to 8 characters.

Likelihood to Recommend

Large scaled, complex, and/or mission-critical applications are well suited to use Oracle Database whether it is OLTP or Data Warehouse. Some COTS software may prefer to use other vendor databases, such as SQL Server. I have also seen vendors use SQL server as metadata repositories for their software.

Verified User

Consultant in Research & Development (Research company, 10,001+ employees)

Vetted Review

20 years of experience

Oracle Rocks!!!

Rating: 10 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

We are using Oracle Database for all of our critical applications for both OLTP and DW usage. It is used across the organization. It provides us a single platform to store all of our critical data and then extract it to use for analytics. It provides us an efficient OLTP database for managing high traffic processing applications

Pros

Nice SGA management
Easy to apply profiles on poorly performing SQLs
One platform for both OLTP and analytics

Cons

Auto SQL tuning
Better LOB management
XML Processing

Likelihood to Recommend

Oracle is mostly good for OLTP based transactions. I see it is limited for the micros service, but I am still exploring that area. Invisible column and identity columns are well used in my applications.

A little more effort on making SQL Developer a better tool could drive the usage a lot more.

Subrat Mishra

Account Director in Information Technology at CCC Information Services (Information Technology and Services, 1001-5000 employees)

Vetted Review

15 years of experience

The most resilient database right now!

Rating: 9 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

The database is very robust and resilient. I like that Oracle is continuously developing and improving it's product.
I work mostly on the enterprise and a lot of HA features. RAC has come a long way from its initial release in 9i and has made my job easier when it comes to troubleshooting and fixing issues. ADG has also come a long way and has resolved a lot of our latency issues and performance issues.

Pros

Active data guard is an awesome feature to have. It helps unload your workload for read-only stuff
RMAN backup makes it easy to backup and restore your database
RAC has helped us make our application available 24/7

Cons

Log collection when troubleshooting
Grid control is very heavy, we need a lighter version just for monitoring and alert triggering
Tablespace fragmentation management tools should be provided
One item in my wish list is that Oracle would make it easier to collect diagnostic files in one command whenever there's an issue. It takes a lot of time collecting TFA files and ADRCI is not enough

Likelihood to Recommend

It is the most resilient database that I've used.

Nanie Asedillo

DBA in Engineering at Salesforce (Information Technology and Services, 10,001+ employees)

Vetted Review

15 years of experience

Oracle Database Rocks

Rating: 9 out of 10

Incentivized

September 17, 2019

Use Cases and Deployment Scope

We use the database for many OLAP and OLTP applications. The database works really great. The error messages could be more informative, however.

Pros

Very robust.
Works great if initial set-up is done correctly.

Cons

Error messages that are displayed can be improved.
Need to improve performance tuning.

Likelihood to Recommend

It is very good for applications where you have OLAP and OLTP's.

Pradeep Vattem

Director - Special Projects in Information Technology at AIOUG (Information Technology and Services, 1-10 employees)

Vetted Review

11 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 (Information Technology & Services, 51-200 employees)

Vetted Review

5 years of experience

View profile