Skip to main content
TrustRadius
Oracle Database

Oracle Database

Overview

What is Oracle Database?

Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered.…

Read more
Recent Reviews

Money Well Spent!

10 out of 10
June 23, 2022
Incentivized
[Our] Entire organizational data is placed in Oracle 12c. We, as an organization are extremely satisfied with the performance and the …
Continue reading

Review

10 out of 10
April 29, 2021
Incentivized
Oracle 12c is used to support the shopping website of the organization, it's very robust, high performing and THE database is scalable to …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Oracle Database?

Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

164 people also want pricing

Alternatives Pricing

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

What is TeamDesk?

TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.

Return to navigation

Product Details

What is Oracle Database?

Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.

Oracle Database Video

Oracle's Converged Database

Oracle Database Competitors

Oracle Database Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.

PostgreSQL and MariaDB Platform are common alternatives for Oracle Database.

Reviewers rate Support Rating highest, with a score of 10.

The most common users of Oracle Database are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(1193)

Attribute Ratings

Reviews

(26-50 of 178)
Companies can't remove reviews or game the system. Here's why
October 23, 2019

Oracle DB

Score 9 out of 10
Vetted Review
ResellerIncentivized
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.
  • Growth capability- Will allow you to grow and upgrade from std to enterprise edition as needed for functionality
  • Security options available
  • Enterprise level product
  • 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
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
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
October 14, 2019

Oracle Database Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is being used by all Oracle Utility Applications and is a single option for all data needs. The Oracle Exadata Hardware with Oracle Database helped with a lot of performance issues and dealing with terabytes of data.
  • High performance.
  • Robust.
  • Excellent support for all kinds of integration.
  • Documentation needs to be better.
  • Compatibility.
  • Costs.
Oracle Database is suited for large data handling and is not suited for medium or low data handling.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database 12c is used by multiple departments at our company. It is the backend database for a number of applications that we run, both Oracle provided applications and supported applications. It addresses the performance and daily functions of our business. We use it for a variety of functions from customer-facing to internal apps.
  • Oracle 12c offers many new features that are performing well. Online partitioning has been a large benefit that was not offered in past versions.
  • From a larger perspective, I think that Oracle 12c Database offers better performance than Microsoft SQL Server does.
  • Oracle 12c allows the ability to restore just one table via RMAN and that allows us to save time.
  • Oracle 12c has some slight differences from version 12.1 to 12.2 that have forced us to recode or alter DDL to allow the same features to work.
  • I wish that RMAN would error out at the beginning instead of the end when there are version discrepancies.
Oracle 12c has been a great performer for us, and it is handling out database loads and batch runs well. So far there has not been a scenario where we would prefer to run on an older version or other software. The only reason that we have other versions in place is that the applications do not support version 12c.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is used as our OLTP databases. It is being used by a couple of departments at my company.
  • Autonomous database
  • Exadata
  • RAC
  • Big data
  • Data Analytics
  • ERP
If you have two active nodes and each node is in a different location, Oracle has a different solution for it. Oracle Database with Exadata is the best solution for an OLTP or OLAP system.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Large set of data can be stored & retrieved easily
  • Cloud based so can retrieve from anywhere, anytime
  • Difficult for beginners to learn
  • Not optimized for low performance systems
  • License is expensive
Oracle 12c is not optimized for low performance systems and makes it difficult for beginners to try it when learning.
September 30, 2019

#1 Database on the market!

Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
  • 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.
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I upgraded all Oracle production databases (about 15 production databases) from 11g R2 to 12c R2. The Oracle 12c databases are used university-wide, and are really critical to the university business.
  • I believe other users have reviewed the pros already. I am addressing only the Cons of 12c R2.
  • SYSAUX tablespace grows rapidly. I didn't need to add space to SYSAUX last a few years in 11g. But after upgrading to 12c R2 12.2.0.1, SYSAUX grows daily, and I have to add space to SYSAUX regularly, about every 2 weeks. I am currently opening an Oracle SR and working with Oracle Support on this issue.
  • Some of our small databases only use about 5GB excluding SYSAUX. But SYSAUX uses 5GB alone!
  • Almost all universities (if not all) in the USA have been using Banner application. But Banner app users fail to log on 12c Release 2 databases after upgrading to 12c R2 from 11g because of an Oracle Bug related to password-protected profile. I applied an interim bug to work around this issue. However, since Oct 2018, the PSU patching will not work. I must rollback the interim bug, and then patch the PSU, and then apply the interim patch again to resolve the Oracle bug. I asked Oracle to include the interim in the PSU in Oct 2018. But up to PSU Jul 2019, Oracle didn't implement it yet!
One of the features that benefits me is that it is able to set up an audit on specific tables to specific users, via setup Audit policy.
September 19, 2019

Oracle Database 12c review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is being used by my organization as the primary database for data storage. We use it with hibernate to be able to develop in Java and use the database in an object-oriented way.
  • Reliability.
  • Performance.
  • Scalability.
  • It's hard to set up in different environments.
The product uses standard SQL query language (easy to use) and it is very stable. I would recommend to businesses managing lots of data.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database 12c is being used across the whole organization. We use it to store payment and card-related data. We prefer Oracle because data consistency is very important to us.
  • Data Consistency
  • Slow Availability
For transaction and payment related data where consistency is of the utmost importance.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We primarily use Oracle in our organization, except for a few applications which use other databases like PostgresSQL, SQL Server, etc. Primarily DB is used to manage data for various applications all across the organization by multiple applications. Now, with some of the new applications, they are using some AWS or third-party databases as well.
  • First of all DB needs to be upgraded to Oracle 12c for support prospective from Oracle.
  • Oracle 12 has some great features with respect to auditing.
  • Keeping the data with respect to hot and cold rows is also a great features helping in managing data well.
  • It had installation issues where it needed to have a patch applied before installation could begin. Downloaded software should have been tested before providing it to the user.
  • Oracle 12.1 was not very stable so we had to migrate it to 12.2 after some time.
Most of the functionality needed by the application was already supported by 12c, so I did not explore any other features needed. I believe 12c may not be suitable for applications with a small footprint due to larger infrastructure requirements. That is why many developers have chosen databases such as PostgresSQL or MongoDB.
September 19, 2019

Database 12C in site

Score 7 out of 10
Vetted Review
Verified User
Incentivized
It is used to store all student and business data throughout the university.
  • Speed
  • Security
  • Up-time
  • Usability
  • Ease of use
  • Setup
It's the back bone of most global databases so its scalable to most any needs. The education to be a DBA and the demand caused the price to manage to grow 10-25% YOY
September 18, 2019

Oracle Database Review

Score 10 out of 10
Vetted Review
ResellerIncentivized
Oracle Database is the principal database engine for the operations of my company because is a big enterprise, it is managing millions of records of information about final users. Great features combined like Real Application Clusters, Dataguard, and ASM are just a few of the great things that Oracle Database offers. In addition, we are an Oracle partner and deploy Oracle database in the infrastructure of external customers.
  • Complex engine with powerful flexibility.
  • Recoverable at the lowest level.
  • Works worldwide.
  • SQL plus rendition like in Windows environments.
I would recommend it for telecommunication companies due to the volume of information managed by these companies.
September 18, 2019

Reliable DB for Gov

Score 10 out of 10
Vetted Review
Verified User
Incentivized
Most of our data is housed in Oracle Database 12c. It is used lots with other BI tools to get a pulse on the data and pull reports for the organization.
  • Ease of use
  • SQL syntax is robust
  • Reliable
Works well with Cognos. I would recommend Oracle Database 12c for any organization that needs a reliable, robust and industry-tested DB.
September 18, 2019

Oracle Database 12c Review

Seshagiri Parupalli | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Ellucian Banner for the college. The backend is an Oracle database. We are currently on 11.2.0.4 and are planning to upgrade to 12.2.0.1. I also have some databases on 12.1.0.2.
  • Easy to manage and maintain.
  • Backup and cloning to development instances are easy.
  • Restoring a full database or a particular table is easy.
  • Performance was better compared to 11gR2.
  • Oracle LOBs is still an issue.
  • Function-based indexes are still a problem
  • Query optimization needs improvement.
Higher education is well suited for Oracle Database 12c. We also recommend 12c to the HR and Financial Aid departments within our college.
Frank Lupercio | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Multiple departments use Oracle and different software use connections to multiple databases that are in Oracle. It allows connectivity with all applications and it's useful for all the reporting tools we have. We can keep all our customer data in one central location.
  • Oracle allows you to connect to multiple reporting tools.
  • Oracle has extensive patches and distributes them in a timely manner when they release them.
  • They can handle multiple databases and hold tons of data history.
  • It is very reliable and doesn't crash like other products.
  • SQL Developer lacks functionality that would be useful, like displaying all records at once when you query
  • SQL Developer crashes a lot and it is buggy. We would love to use it more but it is hard to use at times.
  • They haven't or don't release Oracle Data tools for Visual Studio 2019. We are almost at the end of the year 2019 and still no data tools yet.
  • Connection to .NET is kind of complicated and not very easy as compared to Microsoft SQL Server that allows you to connect easier.
  • Oracle, in general, doesn't compare in terms of use with SQL Server. Data takes a little bit longer to get pulled when you create .Net applications.
  • Connections have to be opened and closed or else you can end up with multiple connections open. As opposed to SQL Server where it opens the connection and it is closed immediately with very little code.
  • Oracle doesn't provide many examples of how Oracle implements and interacts with .NET.
Well suited for large data and for complex applications. It is great, secure, and support, in general, is good.

Not well suited for small companies (cost) and for home projects. There is not a smaller version of Oracle available for home use like SQL Server. You can find many free options for your home or small business without having to pay thousands of dollars compared to Oracle.
September 18, 2019

Oracle Database 12c Rocks

Ken Turner | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
80-85 percent of data from the university is stored on an Oracle Database and all apps connect to our DB.
  • Recovery. Recovering the database is more reliable than any other I know of.
  • Speed and performance.
  • Reliable.
  • Querying large amounts of data, fast.
  • Recovery of a database to a point in time needs to be easier.
The Oracle Database is well suited in any environment that needs to store large amounts of data or support multiple applications across different platforms.
September 18, 2019

The Oracle Way

Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is being used for applications used by different business units across the organization.
  • The database is extremely fast compared to other databases we evaluated.
  • Queries can be easily diagnosed with different toolsets that Oracle provides. You need to have experience to read it, but once you are able to, the information is valuable to decide what options to improve SQL performance.
  • SQLPlus is essential for me to easily create dynamic or run-time queries to be executed in the Oracle Database.
  • The information from the Oracle toolsets to diagnose performance can be a bit daunting if you do not know what to look for.
  • It would be cool to easily identify issues such as stale indexes, missing indexes, etc. with a click of a button. The execution plan should show that issue easily.
From the databases we evaluated, the Oracle Database was more efficient and effective in running our application.
September 18, 2019

Oracle and VSE Corp

Score 9 out of 10
Vetted Review
Verified User
Incentivized
The Oracle database is currently what houses our data in relation to our corporate ERP system. The database sits on an Oracle Database 12c appliance for ease of access and use. On the ODA, this Oracle Database 12c is 1 of 5. Also running in parallel are another five that run for production, testing, and development. This database and architecture were selected for performance and security reasons
  • Performance - We have several ERP systems all running on various platforms. By far the best performance in terms of consistency being up and available is our Oracle platform. To put into scale, out of all three platforms, since I have been employed, Oracle has not been down once, while the other two have been down multiple times, to the point that my attendance at OOW2019 is focused on migration from other platforms to Oracle.
  • Security - The matter of security is huge. One of the biggest points in choosing an Oracle database and appliance over anything else is the security it provides in counter to anything else on the market.
  • Training - While there is an enormous amount of training available, there are still gaps in terms of availability for classroom-style learning. I have found it more effective to be in a classroom setting where one is held accountable at that moment in time as opposed to self-paced (pure personal preference).
  • Cost - While we love the databases and appliances, the cost of maintaining is becoming an issue when competitors are coming in at such a lower point. Pushing this to a more profits oriented C-level makes justification difficult at times.
Well suited as the base backend structure for any ERP system or for EDW structure in the cloud. Less appropriate for a small business start-up.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is being used across departments. We used it to automate our audit and compliance cases, as well as case management. This year we be implementing 100% of our case management, and all new audits will be worked in the system as well. Currently, 100% of our compliance cases are worked within the database.
  • An automated case management system has eliminated our duplication of effort in most instances.
  • Having electronic work papers has allowed us to access other case files so we have access to more data saving us time and stopping the need for duplicate request.
  • Our compliance cases are very task-oriented and the out of the box flow works very well with these cases.
  • From the audit perspective, we have had to customize a lot to meet our electronic work paper needs.
  • We have quite a few open Oracle service requests that have been outstanding for years.
  • The history around the completed task is lacking out of the box.
For compliance activities, it is very useful. It also works very well for managing all of our different case types. From an audit perspective, I wouldn't recommend it based on all the needed customization. Over customization has also led to performance issues. This may be, in part, a product of our agency as well as some limitations of the database.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is great. We work with it every day and it's an important tool to provide value & info to our senior management. I manage a 20 person team and we are intensive users. We have to extract and process profitability information for reports, quickly. We know we can trust it and that our information is safe and easily accessible.
  • We have our really sensitive information and we trust our information is secure.
  • It's fast, and we need that for our everyday work.
  • The Oracle client could have some discovery tools, like graphic reports
  • We could use some machine learning capabilities
  • It would be great if we could generate some graph directly from the client tools
It can handle enormous amounts of information and we can be sure that the processing will be fast enough. Our company deals with large volumes of information.

It would be great if we could have some graph reports with no need for additional tools so we could avoid to having to develop new tools for reports.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database is used across the whole organization. We use it for data collections and index calculations for various in-house government programs. We also have front end applications written in Java using Oracle Database.
  • Very strong relational database
  • Easy to maintain
  • Access to support 24/7
  • Should be able to create temporary tables, like we do in Sybase, dynamically inside code
Well suited for running applications using large amounts of data.
September 18, 2019

Oracle Rocks!!!

Score 10 out of 10
Vetted Review
Verified User
Incentivized
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
  • Nice SGA management
  • Easy to apply profiles on poorly performing SQLs
  • One platform for both OLTP and analytics
  • Auto SQL tuning
  • Better LOB management
  • XML Processing
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.
September 18, 2019

My Oracle Database Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Oracle Database in our department for storing critical data.
  • Performance is good if we have the right technical resources.
  • Good analytics functions.
  • Easy to use.
  • Built-in querying tools
  • Make it easy to install/improvements in installing the database.
It's suited to hosting a large volume of data. It has good performance but lacks good querying tools.
Return to navigation