Oracle 12c

From Oracle FAQ
Jump to: navigation, search

Oracle 12c is a version of the Oracle Database. The "c" stands for "cloud" to indicate that 12c is "cloud enabled". It features a new multi-tenant option that will help companies to consolidate databases into private or public clouds.

History and Support Status[edit]

Oracle 12c version 12.1.0.1 was released on 1 July 2013. The latest patch-set is Oracle 12.1.0.2.

Database options[edit]

Mostly the same as for Oracle 11R2, with the following exceptions:

  • New Oracle Multitenant option introduced. It is free with EE for a single tenant, otherwise a paid option.
  • Oracle Total Recall (flashback data archive) was enhanced and renamed Oracle Temporal. it is no longer an option and can be used free of charge with the DB software.

New features[edit]

Some of the new features include:

  • Enterprise Manager DB Control was replaced with EM DB Express
  • Container databases (CDB) with embedded Pluggable Databases (PDB)
  • Automatic Data Optimization (ADO) with heat maps to automate ILM
  • In-Database archiving and Temporal Validity
  • Unified auditing
  • Database privilege analysis to see who uses what privileges
  • Data redaction
  • Adaptive Query Optimization
  • Database Migration Assistant for Unicode (DMU) replaces "csscan" and "csalter"
  • Row Limiting Queries
  • Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types
  • Online move of data files and partitions
  • Assiging Sequence values directly at table creation .

External links[edit]

TGV Oracle Database
Oracle 1 | Oracle 2 | Oracle 3 | Oracle 4 | Oracle 5 | Oracle 6 | Oracle 7 | Oracle 8 | Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11gR1 | Oracle 11gR2 | Oracle 12c, Oracle 18c, Oracle 19c