Question

What are the new features in 12c Cloud database?

Answer 1

Performance with Zero effect
Adaptive Query Optimization.- Automatic reoptimization.
Adaptive SQL Plan Management – runs auto verification or evolves process for non-accepted plans using COMPREHENSIVE mode.
Concurrent Statistics Gathering –
Improved Automatic Degree of Parallelism –
Dynamic Statistics –
Enhanced Parallel Statement Queuing –
Online Statistics Gathering for Bulk Loads – Eliminates user intervention by auto stats after bulk data load.
Compressing and Archiving effect
Database hardening: - makes easy to track history for all security tables by improvements in flashback data archive (FDA – User context tracking, Hybrid Columnar Compression, Import and export of history).
Optimize Flashback Data archive History tables: – using OPTIMIZE CLAUSE.
Database Overall
Integrate with Operating System Processor Groups:-makes easy to enable CPU and memory restrictions for an instance by parameter PROCESSOR_GROUP_NAME, to bind instance to a named subset of CPU’s on server.
Data Pump with Full transportable:- move non-CDB/PDB database to another non-CDB/PDB.
Multitenant Architecture: - have many PDB’s inside single oracle database. Gives fast redeployment, fast copy, quickly patch/upgrade of many doing it once.
extends PDB’s point-in-time recovery.
New syntax PLUGGABLE DATABASE, supports pluggable
database backup and recovery.