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?

167 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

(1191)

Attribute Ratings

Reviews

(76-100 of 178)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It's used across the whole organization, as far as I know. So far it solved all the problems per the traditional relational database (such as complex processing and faster performance), but It's not helping with the cloud. We're thinking about moving to a Cloud-Native database because we're looking for a dynamic database (not as static).
  • It's the best one in terms of Relational Database with the support to indexing, maintaining relations between the tables, etc.
  • Faster performance in fetching results, especially when running complex queries with multiple tables.
  • There's no easy way to Store JSON objects in the DB. We had to do some workarounds.
  • We need a little more detailed explanations for the exceptions or errors thrown. For example, if it reaches a session limit while fetching a connection, it's better to throw the count in there that X of X are currently in use, etc.
It's well suited for the relational Database where there are huge sets of data to be processed in real-time.
It's not currently Suited for the Cloud Environment. Like an easy add-on service to the apps in Cloud Foundry Services, expect Oracle Cloud.
September 17, 2019

I Like it

Score 10 out of 10
Vetted Review
Verified User
Incentivized
We provide consultancy service to a company's different sectors. In my account, we service a company in the financial sector. We provide services such as change and incident management, we work on service requests to provide access and manage users privileges, and troubleshoot performance issues at the query level to avoid impacts on established SLAs.
  • Provide edge technology.
  • Customer support is sometimes bad and if the ticket is not high priority It could take a lot of time to be attended to.
For data warehouse environments, it is a great option. We used to run it using a non-EXA appliance and batches used to take like 3 to 4 hours but it was reduced to 30 min which helped our customers. I think Oracle has an option for any need that any customer has.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is being used by our organization as a source of truth for many use cases.
  • Disaster recovery solutions.
  • Replication solutions.
  • Performance, Tuning, and Troubleshooting should be simplified and all the data needed for troubleshooting should be in one easy to access place.
Oracle Database is well for all finance-related applications but may not be well suited for processing big datasets.
September 16, 2019

Oracle Database 12c review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database 12c is being used for storing data and supporting applications for recording statistical processes of the Census Bureau. It provides a solution for storing critical business information.
  • Faster data management.
  • Better options for automating DBA functions.
  • Cloning and backup.
  • Security and encryption should be simplified.
  • Customer Support response time should be better.
  • The OEM is too slow.
Oracle Database 12c is still the best RDBMS software product, with superior functionality and tolerance.
Score 9 out of 10
Vetted Review
ResellerIncentivized
I support the decision-makers in deciding the database platform to use, both on-premise and within the cloud. The databases are usually operational ones (OLTP) for both custom and ERP applications. Some are enterprise data warehouses. All are to solve business decisions usually within a retail or financial vertical.
  • Complex query - this is true for relational databases but more so for Oracle due to its robust implementation of ANSI-SQL and the relational paradigm for data management.
  • The various options available within the database are second to none. No one has the same level of partitioning as Oracle does for example.
  • Even though some other databases have similar capabilities no one can match Oracle RAC to any real degree.
  • Oracle is slowly moving this was but allowing the database to consume more data repositories and query them all from a single interface would be a great enhancement. Oracle Big SQL has this but is a paid option that sits outside of the database and has access to a small number of repositories (HDFS for example).
  • Make licensing more easily consumable and client-friendly. This is the biggest bone of contention that is pushing customers from what is a truly great product.
Oracle Database is well suited for practically any data store. The hardest portion though is using large objects, such as images, and being able to query those objects.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Oracle Database 12c for our mission-critical databases. It's almost used 60% in our entire organization. Oracle Database 12c has lots of good features that make troubleshooting and diagnosis easy and reduces downtime to the business users.
  • Advanced Index Compression.
  • Approximate Count Distinct.
  • In-Memory Column Store.
  • ConfigToolAllCommands
  • DBMS_DEBUG Package
  • Sharding

If we are using Oracle GoldenGate then Oracle Database 12c works very well if we are using Integrated Extract and IntegratedReplicat.

If we are using classic Extract and Replicat then Oracle 12c R1 is not a good option.

September 16, 2019

Fine and robust product

Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is not used by the whole company, as each individual team picks the tools and/or technologies they want to apply, but many teams in my area use the Oracle Databases for a variety of reasons like to store users data, products they use in our platform, and to store some of our data configurations.
  • Stability.
  • Easy to use.
  • Capabilities.
  • There are other products that are easier to configure.
  • Price.
Oracle Database is good to use when you want to configure events.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database supports critical OLTP and OLAP environment. The database performance and security is the key aspect of our organization, as we deal with customer data. Oracle perfectly matches the business challenge in this.
  • Performance
  • Security
  • Stability
Performance challenges and existing transformation. If you have a new business challenge, it has all the features that you need, very feature rich.
September 16, 2019

Oracle Database is the best

Habeeb Akbar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Our ERP is running on Oracle Database. We have 11 companies using the database, from the finance department, HR, and supply chain. We have issues with optimization and replicating due to slow links.
  • OLTP transactions are so very fast. We have 5,000 concurrent users and results are shown so fast.
  • Compatible with different application vendors and require less configuration. We are using SharePoint, Sales Online, and other applications.
  • Data replication with ADG is very powerfull and requires less latency. Currently, we have real-time replication without much interference.
  • Oracle should have a single implementation method for all platforms regardless of different operating systems.
  • Migration tool for other databases should be quick, without a user interface.
  • Data cleansing and data validation tools needed.
Oracle database is a perfect choice when customers have Oracle hardware and they're looking for relaible OS like Linux and Solaris. Customers who have Oracle applications will find appropriate to have Oracle Database due to single point of support and fewer resource requirements to maintain the data.
Oracle Database will be less appropriate for customers who have a smaller budget and hardware with slower performance.
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using Oracle Database 12c with version 12.2.0.1. Our database administrators upgraded our Oracle Database 11GR2 (11.2.0.1) with ease and started to use our environment with the expansion of new features and tighter security. We are using Oracle Database 12cR2 in the entire company and business users did not understand the upgrade process. As an architect, I used adaptive query optimization and online stats gathering as the new features which address my performance issues. As a developer, an increase of size limit on VARCHAR2, NVARCHAR2 data types, and inline PL/SQL functions and procedures helped me a lot. But having Identity Columns replaced my sequences. As a database administrator, online migration of table partitions or subpartitions helped me to move a part of the table without any deduction of any service. DDL logging helped me to log any type of DDL operations (such as truncate, drop partition or any other DDL statements).
  • Pluggable Database structure
  • Restoring a table easily through RMAN
  • Multiple indexes on a single column
  • Temporary UNDO
  • Columnar tables.
  • Compression after update on HCC (Hybrid Columnar Compression) tables automatically.
  • More analytical functions.
  • More functions in data mining, data science, and machine learning algorithms.
Since I am using Oracle Database 12c for analytical projects and for a data warehousing environment, it is the best of the sector to respond to your query needs as well as development speed and your response to your business users. It has many features to perform your ETLs (Extract & Transform & Load) faster and respond to your business users quicker. Oracle Database 12c is supported by all of the Data Modeling, ETL, BI (Business Intelligence), Data Visualization tools and offers a variety of SQL, PL/SQL editors.
April 10, 2019

SE2 review

Olivier Ameryckx Oliva G. | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
ResellerIncentivized
I use to recommend Oracle Database to my customers to have a better implementation of their database. I helped them to do the best decision, migration or upgrade. More the fact that I support them into their hardware solution in combination with SE2 database.
  • Fast database to run and easy to use
  • Reliable and consistent for implementation and no critical updates
  • The security and encryption options
  • SQL function with support for C library
  • Data and storage partition
  • Migration process
  • Upgrade of new releases
  • Core factor for enterprise edition with HW products
  • VMware clusters to licence
  • Support JSON
Oracle Database 12c is well suited for mission-critical applications or any application where high performance and reliability are required. It extends the application grid to database allowing access to enterprise data and applications in a good infrastructure environment.
March 14, 2019

Oracle Database

Score 10 out of 10
Vetted Review
Verified User
Incentivized
We used Oracle EBS as our ERP software. The underlying database is Oracle. Apart from Oracle EBS we also have other legacy ERP systems that use Oracle Database as the underlying database. Oracle database is used across the whole organization.
  • Oracle DB can handle large amounts of data without any issues. For example, Salesforce processes billions of records every hour in the cloud. Their underlying database is Oracle.
  • Oracle DB provides industrial-strength support for online backup and recovery.
  • Another advantage of Oracle DB is its reliability. Oracle DB delivers excellent performance when challenged with demanding tasks. The ACID test, which is an important tool used to ensure the integrity of data stored, was easily passed by the Oracle database.
  • Oracle database is very expensive. It can cost 9-10x as much as Microsoft SQL Server.
  • Oracle database is an extremely complex engine. Expert knowledge is required to design a database and architecture.
  • You need an expert to maintain an Oracle Database. Day to day maintenance itself require a skilled resource.
Oracle database is well suited for large corporations who have large amounts of data that need to be processed.
Piyush Jain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Oracle Database 12c for larger database structure for those clients who have a larger business and have a lots of data to manage. Although we use MySQL for smaller businesses, Database 12c provides more features compared to MySQL.
  • The need for any other software is not there.
  • There are many features in the Oracle 12c database.
  • Cost is the main factor here which needs improvement. Some clients requirements can be done only with the extra features this product provides but cost comes in between so ultimately we have to use MySQL for that.
  • Technical support also needs improvement.
It is very well suited for larger enterprises or for which we have to handle a larger amount of data in less time. It can also be done using Google BigQuery but as Oracle Database12c is quite popular we have preferred this product for our major clients.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle is our primary relational database for all in-house development. We also have SQL Server, DB2 for z, and DB2 distributed as enterprise-grade installments, but when we get to choose where to put new data, it's almost always in Oracle. It supports our primary OLTP functions, as well as BI and warehouse. The balance of speed, security, and accessibility is what sets it apart.
  • Accessibility. It's very easy to grant end-user access to the data. Oracle has done a fantastic job of providing developer-friendly tools. SQL Developer is a top-notch product, that is completely free for developers. It allows people to easily and clearly query and update data.
  • Education. There is a definite career path laid out by Oracle to develop skills to develop, administer, or use this database, and its peripheral suite of products. Aside from what Oracle itself provides, the user community does really well to encourage knowledge sharing. The user groups are fantastic.
  • Speed. From querying to load and unload utilities, Oracle can perform to your expectations. We use the diagnostic tuning pack to help aid with specific query tuning. As good as the optimizer is, it sometimes still requires a DBA to hint it in the right direction. Adding optimizer hints to SQL is a life-saver.
  • Security. I feel that this is a secure, mature product that stays abreast of the climate with frequent patches. When vulnerabilities are discovered, we are alerted promptly by Oracle.
  • Complexity. The trade-off for the excellent performance and many features is a complex structure. We have 3 different types of DBAs to support various aspects of the system. One focused on application performance and design, another on maintenance and security, and a third on alerting and patches. Each is a full-time job.
  • The push to cloud services is nauseating. It seems like a major focus for Oracle, and something our shop has little interest in.
  • I've never felt that we get our money's worth with support. This is true with almost all software, but I would expect better from Oracle.
  • RAC architecture works as promised, but adds an even greater level of complexity to your system. There are things from an administration standpoint that are not yet consolidated across RAC nodes. For example, if you are looking for a specific user session and run 3 active nodes, you have a search 3 places for it. There should be utilities to traverse all RAC nodes for you. It's 2019. I'd like to see less development for cloud technology and more in that area.
  • The standby database is the same. Works as advised, but adds complexity and extra administration.
So great for in-house development. If you are buying applications off the shelf, you probably don't care what kind of database supports them. But to easily create, alter, and maintain tables, views, etc. nothing beats Oracle in my opinion. A small shop can find some of these features for less money with the other vendors. Licensing costs could be a limiting factor.
Sukesh Nayak | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
As a Oracle Database administrator I administrate various Oracle Database versions in my organization for my client. We have Oracle Database 12C installed in more than 35 production server environments and we are in process of upgrading our 11G databases to 12C. Oracle company introduced Oracle Database 12C with huge number of new features to overcome the limitations of its older versions like 10g ,11g etc. I do installation of Oracle 12C version databases and upgrade my database from 11g to 12c version and administrate Oracle 12c databases. It's really amazing to see Oracle come up with wonderful technologies and features like
1) OEM 12C ,using which I can monitor heterogeneous databases along with Oracle databases, host monitoring, creation of groups, One link for OEM administration whereas in older versions we used to have one OEM link per server and it is really difficult to manage OEM links in huge database server enviornment. 2) Multitenant database 3) Recover table using Rman 4) Full database caching. 5) In 12C we can move data files online. Whereas in prior database versions we had to offline of shutdown the database in order to move data files depending on type of tablespace. 6) Single node RAC, Flex ASM, Flex cluster and many more features.
I had great experience working on Oracle 12C and I highly recommend using 12C as it helps you to secure your database in many ways and gives you wonderful features hence allows easy administration.
  • OEM 12C allows cloud monitoring. We can install OEM on one server and monitor all my databases (11G R2 and above) hence I need to manage just one link. It also allows heterogeneous database monitoring, host monitoring, out offline patching.
  • We do not have an option to recover tables from Rman backup prior to 12C hence we had to be only depending on logical backups.
  • But using 12C database we can recover tables as well.
  • When we look for availability RAC comes to our mind and Oracle Database 12C came up with new features related to ASM and RAC like Flex cluster and Flex ASM using which if at all ASM instance goes down in a RAC node it can make use of asm that is running in other node hence ensuring availability. In Flex cluster we need to have Flex asm and the leaf nodes. There will be no database/ASM instances running in leaf nodes but only the application servers. The incoming connection come to leaf node and then to the actual hub server. Leaf nodes reduce the cost as there is no need for internode communication between leaf nodes. The internode connection should be there within hub nodes.
  • I don't see any such disadvantages but the multitenant structure seems bit complicated and same should be presented in simpler manner
Oracle Database 12C is well suited for large organizations which likes to use RAC environment or cloud environment since we get too many features to avail availability, scalability, performance and who can afford the cost. It is less suitable for small organizations who cannot afford the license cost.
Gabriel Samaroo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The Engineering and Business Intelligence teams use Oracle Database as their primary data store. The Oracle Databases serves as a data warehouse that powers all of our applications. Oracle Database is very reliable and performant. With its many features, it can easily be queried in a SQL client or connected to any application (Java in our case).
  • Great SQL client that allows for advanced querying.
  • Extensive support for stored procedures, functions, materialized views, windowing functions, and other useful SQL operations.
  • Stable. Oracle Database has been around for many years and has a large developer community.
  • Expensive. There are several free alternatives (Postgres, MySQL).
  • More difficult to install and setup than other alternatives (ie: MySQL).
  • Difficult to support and administer (ie: backups).
Oracle Database is very efficient and stable. If you have the money to spend and care a lot about security and availability, then Oracle Database can be a great option. If you're a start-up or don't want to pay anything, there are multiple free alternatives like Postgres and MySQL. Oracle also integrates nicely with many other applications and services, so it might be a good solution depending on your particular platform.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our company is using Oracle databases to support almost all aspects of the business. We use it for our ERP system, Commerce integrations, Marketing, Sales, etc. Since we use many Oracle applications, the Oracle databases go hand in hand as the back end storage mechanism for all the various apps we utilize.
  • Oracle databases are ideal for maintaining data (insert, update, delete).
  • The SQL (Structured Query Language) and PL/SQL (Procedural Language / Structured Query Language) languages are very powerful ways to interact with Oracle databases and retrieve data.
  • The databases have administrator tools that make maintenance of the databases simple.
  • Some error messages tend to be a bit ambiguous.
  • Although Oracle is a relational database, they rules are not strictly enforced. I suppose this allows for more flexibility and customization, but it would be nice to have inherent foreign keys, etc.
  • There have been times where updating the database has resulted in some functionality (i.e. keywords, tuning methods, etc.) to be deprecated which has required my teams to rewrite code.
I find Oracle databases to be top notch at what they are designed to do. There are minor nuisances, but I'm sure all database platforms have some issues. Oracle is often upgrading their databases which introduce new functionality and more powerful ways to interact with the databases. Overall, thoroughly enjoy working with Oracle's products.
Siddharth Walia | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are currently using the Oracle Database as a backend support for the client websites developed at the workplace. The clients are financial institutions all around the world so we have different data centers to ensure high availability. We also use Oracle to keep backups of the data in case of any disasters, so that the vital data could be recovered efficiently. A lot of departments are using Oracle in the company including developers, QA analysts, and the customer support team.
  • Robustness, the way it handles relational databases as well as other services required for a fault-tolerant database environment.
  • Consistency, the reliability of the fact that data is being consistently stored in each transaction.
  • Ease of configuration.
  • Integration with third-party applications.
  • It is pretty expensive, it makes more sense to buy this product if you have a lot of transactions per second.
  • Integration with Microsoft technologies is not as good as Microsoft SQL servers.
  • Other then these, I cannot think of any other areas that require improvements.
Before switching to Oracle Db, make sure that you have a good knowledge of databases, as hiring a new person for this job would be expensive and the tool itself is pretty expensive. Oracle cost model is very complicated so it is worth it to spend some time talking with an Oracle Account Manager and doing some research to find out what is the best to fit your needs and reduce the cost of ownership.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Mostly, we found it very appropriate for one-to-one training sessions. It is very well secured, where firewalls and other content filters are activated, and thus it is extremely reliable. We used Oracle Database 12c in various department and it works great to support virtual environment. It can also be used to archive data.
  • It is robust and scalable.
  • Very easy to handle large quantities of data.
  • Different users can interact with Oracle Database using various tools and applications and thus it can run on a wide range of platforms.
  • It should be easy to use. If you haven't worked on any tool like this, then yes you may need assistance to use this.
  • The licensing cost is bit on a higher side.
  • Customization can be improved.
We found it very useful in Data Import and Export. It provides great tools to send data in and out of the database in quickly manner.
yixiang Shan | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database, has been used as the Enterprise Data Storage solution for many years in our company. Even today, when a lot of new NoSQL database products pop up, more than 80% of corporate and regional data is still stored in Oracle Database. Oracle Database serves us well in most of the business use cases, performance wise and stability wise, in different domains like operation, clearance, reporting and post ops analysis.
  • We have databases in two data centers geographically located in different places in our region. The Oracle 12c Data Guard feature makes sure the data instance is synchronized in a near real-time manner from the primary instance to the standby instance, across the data centers to provide data center level failure resilience.
  • Database instance's high availability is guaranteed by the RAC feature, which also helps us scale up resources like servers, CPU and memory.
  • Performance tuning toolset provided by Oracle Database is quite handy.
  • The security feature is extremely important for our company, and we are quite happy about what is offered by Oracle Database.
  • Oracle DB doesn't work very well for dealing with a large amount of time series based data rows performance wise.
  • The traditional primary/standby mode of data guard architecture, causing half of the resources (Stand-By side) to be idle most of the time and become a wasted investment. In the future, the near real-time data sync should be made available on the standby side and should allow the read-only operation, so at least business can use the resources for data analytic purposes. That will be great
  • When traditional relational database architecture is challenged by the NoSQL Technics, in most of the case, the business or the end user is not looking for some "Oracle DB" replacement solution, instead, they are seeking a "hybrid" solution. As they get used to the Oracle environment and they like the ACID operation, what they are looking for the flexibility features that are provided by pure NoSQL products (like variable columns for different rows in the same table etc). Oracle has some improvements like security file on BLOB, but if Oracle can make more improvements aiming in this direction, that can bring more added value and retain a lot of old users
  • For some use cases, we noticed that database performance deteriorating if we have relatively high active connection sessions
Oracle Database 12c is very suitable for the Enterprise to deal with well defined structured data, requiring a good balance between the data set and the query performance. It is also well suited for during data insertion time when it is hard to predict how the query will be made (index later strategy). If the business requires highly reliable transaction-based ACID operations and high-security standards, Oracle is one of the best options. While Oracle is not suitable for applying data analytic tasks to extremely large amounts of data (which is not Oracle's issue, it is SQL's limitation), a distributed solution like Hadoop or Cassandra should be considered.
Omar Faruq | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Ours is a software product development company (SaaS). All our databases including OLTP and Data Warehouse are on Oracle 12c. It is the most reliable, scalable, performance focused and manageable database available in the industry to the best of my knowledge and experience. It gave us the flexibility to scale easily and manage our complex requirements.
  • The Oracle optimizer is getting smarter in every Oracle release. In 12c, the adaptive query optimization features helped a lot to improve query performance.
  • In 12c, we can restore a single table from RMAN backups - it's a very useful and time-saving feature when we need to recover a particular software module.
  • I see the scope of improving the optimizer capabilities to automatically handle run-away queries better, meaning, if a SQL suddenly comes up with a bad execution plan, the database needs to be able to handle it smoothly, rather than affecting other SQL.
If there is a need of a scalable and most performing database, I would highly recommend Oracle 12c (and the latest releases).
Nagabhushan Krishnappa | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is used within the organisation. We face performance problems during heavy loads.
  • Parallel Querying
  • Optimizing the queries during execution
  • Better performance
  • CDB & PDB technologies
  • Gather stats collection
  • Parallel querying
  • Accessing the data from physical disks
CDB & PDB Architecture is very helpful for the business objectives.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle Database 12c is used by almost every team in the organisation. It is our primary RDBMS setup, and our entire tech stack is built around it. All our business applications and services run on top of Oracle Database 12c. The biggest benefit from using Database 12c is the reliability. In all the years of using any Oracle Database, we have seldom encountered issues that were solely database-centered.
  • High reliability. Zero hiccups!
  • Possibly the best data security money can buy
  • Allows single table restoration from backups (this feature is brilliant)
  • The handler for bad queries could be better
  • Compared to previous versions, Oracle 12c is a pretty heavy setup. If your business is considering an upgrade, ensure that you perform a pre-check of your systems' ability to work well with the requirements of 12c.
One of the best things about using Oracle Database 12c (or any Oracle Database) is that it integrated beautifully with other Oracle applications and products. If the tech stack of your organisation predominantly includes Oracle products, I would recommend that you blindly go for Oracle Database 12c as your primary RDBMS setup.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It is being used for the company business needs across the whole organization. Oracle 12c is very robust, highly reliable and stable with high availability. It is being used for financial accounting, online purchases; the backend database is also used for reporting and data processing. Also, several other in-house applications use Oracle Database 12c at the backend.
  • Highly Secure
  • Scalable
  • Oracle Database 12c has the new multitenant feature - where companies can consolidate multiple databases from different servers under a single container database thereby helping with cost cutting as well
  • Robust Backup and Recovery technology
  • Database Performance and Tuning Requires skills
  • Managing Social Media types of data
  • Always there are bugs and involves heavy maintenance
  • Well suited for all mission critical large scale businesses and applications and for documentation and social media data
November 15, 2018

12c quick review

Mike Ngong | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle 12c is the only Oracle production database we are currently utilizing. The single pluggable database has so far worked very well for us and we are considering licensing multiple pluggables as we grow.
  • Pluggable databases, as mentioned
  • Temporary undo
  • Invisible columns indexes
  • PGA limit
  • Identity columns
  • Multiple indexes on a single column
  • Cost
  • Optimizer could be better. Many times generating stats on individual objects throws the optimizer off . Rather than utilizing the older better stats it uses the newer bad stats for specific queries
  • Patching without taking down db.
  • Ways to change parameters and force them to stay without taking down db
  • OEM should be included in cost.
  • Hard to learn as a newbie.
  • Very expensive for startups
Not suited for very small companies especially as pluggables are becoming mandatory.
Return to navigation