Oracle Database Information 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

43 Reviews

InformationComputer Software27Internet7Telecommunications7Information Services2

Oracle Database: The Best in Business & Totally Worth

Rating: 9 out of 10

Incentivized

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.

Alternatives

Microsoft SQL Server, SAP HANA Cloud, MySQL, SAP Adaptive Server Enterprise (ASE), legacy, SAP SQL Anywhere, Db2 and PostgreSQL

Oracle Database is best in business, consistent, and robust. Even the standard version is sufficient for the best performance. The main thing is I have never seen corruption and in my opinion, it is best when used with Linux.

Verified User

Consultant in Information Technology (Computer Software company, 201-500 employees)

Vetted Review

8 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.

Verified User

Employee in Quality Assurance (Computer Software company, 1001-5000 employees)

Vetted Review

1 year of experience

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:

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.

Alternatives

Azure Databases

Azure databases is another cloud database that I had used in some .net platform based projects. Both of the cloud database services are identical in nature of usage but very different in scope of usage. But this doesn't mean that the Oracle Database Cloud Service stacks up against Azure databases. Both are different in their scope of usage and implementation.

Abdul Wahab Khan

Project Manager in Professional Services at Softronic Systems (Pvt) Limited (Computer Software, 51-200 employees)

Vetted Review

1 year of experience

My review of Oracle Database

Rating: 6 out of 10

Incentivized

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.

Alternatives

MySQL

It depends on the use case. Oracle database is for everyone, but if it's a lightweight application, MySQL might be an easier choice.

Verified User

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

Vetted Review

8 years of experience

Solid and reliable ACID complaint transactional database by oracle!

Rating: 8 out of 10

Incentivized

Use Cases and Deployment Scope

Oracle database 12c is being used as the main transactional database by my organization. It's primarily managed by the database administration and batch data processing teams. The business problems it addresses is the need to reliably and consistently store data that requires complete consistency and has a lot of capability to be queried in the future for analytics. The Oracle database does transactions the best with it's ACID compliant framework that gives us confidence that data will be stored reliably.

Pros

ACID transactions
Reliability
Scalability
Top notch documentation
Data storage and administration

Cons

Error code explanations
Pricing for smaller organizations
Innovation to meeting newer database standards
NoSQL could be preferable

Likelihood to Recommend

Oracle Database 12c is a solid, relational ACID compliant database that can be used even for the heaviest workloads to store data in a way that ensures integrity and reliability. It's less appropriate in situations where you have nonrelational data and could use a document based database as storage method. Oracle is still primarily relational data storage.

Verified User

Consultant in Information Technology (Internet company, 51-200 employees)

Vetted Review

2 years of experience

Oracle 12c feedback in ERMX

Rating: 10 out of 10

Incentivized

Use Cases and Deployment Scope

We use Oracle Database 12c in our transactional system named Watts. It allows us to have a reliable platform to handle our car ticket product where users can pay for fuel, reload balances, and obtain consumer reports per vehicle. He have 2 clusters of Oracle 12c to warranty high availability and also to handle our DRP. We recommend Oracle products because the support, price and their technology is very robust and reliable.

Pros

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.

Cons

It's hard to find Oracle specialists.
Oracle specialists are expensive.

Likelihood to Recommend

We primarily use Oracle in our organization, except for a few applications which use other databases like SQL Server, Redis and MongoDB. Primarily, Oracle Database 12c is used to manage data for various applications all across the organization by multiple applications like Ticket Car, DataMart, ERP for invoicing and master catalog, and for Watts processor by Edenred Brasil.

Alternatives

Microsoft SQL Server and DB2

We use IBM DB2 in AS400 to handle part of our accounting system and our legacy ERP. We are migrating all functionalities to Oracle Database 12c because it is more secure and stable. We have some applications using SQL Server but we want to handle those systems in it because at this moment, transitioning would mean investing a lot of money into it.

Eduin Zuloaga

IT Architecture Manager in Information Technology at Edenred México (Computer Software, 501-1000 employees)

Vetted Review

9 years of experience

Looking for scalable and reliability? answer is Oracle!

Rating: 10 out of 10

Incentivized

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.

Alternatives

SAP HANA, Microsoft SQL Server and PostgreSQL

Well, I use all sorts of databases at once as it's part of customer requirement.

Verified User

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

Vetted Review

3 years of experience

Oracle DB

Rating: 9 out of 10

Incentivized

Use Cases and Deployment Scope

Cornerstone utilizes Oracle DB at our organization as well as recommends to other organizations for purchase as well as manages existing Oracle DB installations. We provide managed services for organizations that have the Oracle DB. Additionally we upgrade older versions to the newer version of the DB.

Pros

Growth capability- Will allow you to grow and upgrade from std to enterprise edition as needed for functionality
Security options available
Enterprise level product

Cons

Can be pricing if run on commodity servers when you don't need full capacity because of licensing
Std Edition has limited features and often needs to be upgraded to Enterprise edition
Can be complicated to install properly

Likelihood to Recommend

Standard edition for small organizations that don't need partitioning or multi-tenant capabilities. Runs best on Oracle engineered systems and has much more licensing flexibility

Alternatives

Microsoft SQL Server

Both have good functionality. Oracle Database runs better on the Oracle engineered systems and provides a better cost model on those servers. Has better security and a more enterprise ready solution.

greg van stekelenburg

Sales in Sales at cornestone data systems (Computer Software, 1-10 employees)

Vetted Review

Reseller

1 year of experience

Tekvista's Oracle DB 12 c Review

Rating: 9 out of 10

Incentivized

Use Cases and Deployment Scope

Oracle Database 12 C is used by our entire organization. It is used for our data repository. Oracle 12c has number of features and easily scalable for enterpise requirements. Along with the features, support is provided for integration with different platforms which helps in building applications with different technologies possible.

Pros

Large set of data can be stored & retrieved easily
Cloud based so can retrieve from anywhere, anytime

Cons

Difficult for beginners to learn
Not optimized for low performance systems
License is expensive

Likelihood to Recommend

Oracle 12c is not optimized for low performance systems and makes it difficult for beginners to try it when learning.

Alternatives

Oracle is in the leader of the pack. It has excellent user community and support is superb. It is widely used by 75% of organizations from small, medium, large to enterprise wide organizations.

Binu Nair

Software Architect in Information Technology at Tekvista, Inc (Computer Software, 11-50 employees)

Vetted Review

15 years of experience

Oracle Database - They are expensive for a reason

Rating: 9 out of 10

Incentivized

Use Cases and Deployment Scope

Oracle database is the primary backend data storage software at the client. Multiple instances installed across the network support both custom-built applications and Oracle’s applications like OID and OBIEE.

Pros

Redundancy and High Availability via grid setup has a proven track record in securing data availability across applications
Speed of data access across the network is another critical point in which Oracle consistently outperformed others
Support from Oracle is another reason for clients to keep Oracle databases

Cons

Oracle databases have started coming in different flavors, from express to enterprise, but a consolidated management tool that can cater to an enterprise can be improved.

Likelihood to Recommend

Enterprise data management is where Oracle really shines. While open source databases come in handy for smaller environments, Security and Availability are what keep Oracle databases above the competition.