Oracle DB12c for OLTP or DWH usage
April 11, 2019

Oracle DB12c for OLTP or DWH usage

Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

We are using Oracle Database 12c with version Our database administrators upgraded our Oracle Database 11GR2 ( 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.
  • Fast upgrade process.
  • Easy to maintain.
  • Smarter usage of hardware.
Since we were already using a previous version or Oracle Database 12c, there was not much of an evaluation or comparison of similar products.
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.