TrustRadius: an HG Insights company
Oracle Database Logo

Oracle Database Reviews and Ratings

Rating: 8 out of 10
Score
8 out of 10

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

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.

Vetted Review
Oracle Database
5 years of experience

Oracle Database: The Best in Business & Totally Worth

Rating: 9 out of 10

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.

Vetted Review
Oracle Database
8 years of experience

Oracle Database - Harnessing the Power of Data

Rating: 9 out of 10
Incentivized

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.

Vetted Review
Oracle Database
9 years of experience

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

Rating: 9 out of 10
Incentivized

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.

Vetted Review
Oracle Database
15 years of experience

Oracle Database a tool that can sotre

Rating: 9 out of 10
Incentivized

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.

Vetted Review
Oracle Database
1 year of experience

Dump the data and see the magic!!!

Rating: 8 out of 10
Incentivized

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.

Stable but Expensive and Tough to Use Enterprise Database Platform

Rating: 3 out of 10
Incentivized

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.

Vetted Review
Oracle Database
15 years of experience

My Succinct Oracle Database Satisfaction Recap

Rating: 8 out of 10
Incentivized

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.

Oracle Database Cloud Service to reduce the efforts and cost

Rating: 9 out of 10
Incentivized

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:

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

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:

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

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

Rating: 10 out of 10
Incentivized

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.

Vetted Review
Oracle Database
19 years of experience