Oracle database 12c comes with greater reliability, scalability and security
Updated December 14, 2018

Oracle database 12c comes with greater reliability, scalability and security

Omar Faruq | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

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.

Pros

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

Cons

  • 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.
  • Oracle database 12c is very stable, it reduced a lot of downtime for us, thus we have a greater ROI.
It's easy to scale an Oracle database compared to any others, it's easy to manage many Oracle databases together with lots of administrative and security features.
If there is a need of a scalable and most performing database, I would highly recommend Oracle 12c (and the latest releases).

Using Oracle Database 12c

30 - The web-based software application development is done on Oracle Database 12c version, all the health care information is saved and served through the 12c database. Also, the Business Intelligence built on the 12c data warehouse.
10 - The DBA team having at least one years + experience supports the 12c databases on development environment, testing and production environment as well.
  • It is the main production Transactional Database for web-based applications
  • It is the underlying Data Warehouse Database for Business Intelligence applications
  • It helps us to scale the software product and services at ease with a lower operational and management cost
  • We did not have to do any tweak to use 12c databases, all the features behaving according to the expectations. We are taking advantages of advanced compressions which reduced our storage usage about 40% and with greater performance.
  • We are looking forward to using multitenant features of 12c which will help us consolidates many databases altogether and will reduce overall cost drastically.
It is very likely to use this 12c (or next version) of Oracle Database. Nothing close to it in the marketplace in terms of performance, reliability and overall database management efficiency. If Oracle did one thing really good - it is it's OLTP Database I must say.

Evaluating Oracle Database 12c and Competitors

  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
The features we needed, the stability and scalability we looked for, I believe Oracle database was the right choice.

Oracle Database 12c Implementation

Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens.
Yes - 1. Training, research & PoC implementations
2. Implement and test in development environments
3. Implement and test in beta environments
4. Implement in a secondary site in production with zero downtime
5. Implement in primary site in production
6. Go Live during a weekend when there is considerably low usage and monitor closely
Change management was minimal - All teams must work together and must have ongoing regular meetings during the implementation phase.
  • We hit a problem during the upgrade process, the halfway through the upgrade caused error, then it was resolved with the help of Oracle Support.

Oracle Database 12c Support

Most of the time the Support is good and respond according to the expectations. However, there were occasions where it took a long time to get the issue resolved, needed escalations.
ProsCons
Quick Resolution
Good followup
Kept well informed
Immediate help available
Support cares about my success
Quick Initial Response
Need to explain problems multiple times
Yes - Yes most of the time.
When we initially migrate to 12c version from 11gR2, there was a problem in the upgrade process and upgrade failed in the middle-way. It was one of the production databases and we were counting times to bring up the databases. Oracle Support helped us 24/7 basis to get the issue resolved with proper guidelines and documentation - the process was smooth and quick because of Support.

Using Oracle Database 12c

As an OLTP Database, this is simply unbeatable, best in the industry, we have not found any limitations in scalability. Also, it works great as a Data Warehouse.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
None
  • The online database management and maintenance tasks
  • The SQL Plan stability and query performance
  • The overall database management, problem diagnosis and tuning
  • Nothing mentionable. However, sometimes we hit by a bug, which needed Oracle Support intervention to get resolved.

Comments

More Reviews of Oracle Database