top of page
Writer's pictureBalaaji Dhananjayan

Oracle database features and enhancements

Surf through this page to know about features and enhancements that were released on each version from 12cR1. I'll try to cover these features one by one in my future posts.

12.1.0.1 Onwards -

  • Create and Configure a Container Database (CDB)

  • Create and Configure a Pluggable Database (PDB)

  • Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB)

  • Connect, Manage, Administer Container Databases (CDB) and Pluggable Databases (PDB)

  • Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB)

  • Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB)

  • Manage Users and Privileges For Container Databases (CDB) and Pluggable Databases (PDB)

  • Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB)

  • Flashback of a Container Database (CDB)

  • Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB)

  • RMAN (BACKUP VALIDATE, RESTORE VALIDATE, RECOVERY VALIDATE)

  • Database Triggers on Pluggable Databases (PDBs)

  • Transparent Data Encryption (TDE) in Pluggable Databases (PDBs)

  • PDBs With Different Time Zones to the CDB

  • Pluggable Database (PDB) Names Modify

  • Upgrade a PDB using Unplug/Plugin

  • Recovery Manager (RMAN) Database Duplication Enhancements : Multitenant Considerations

  • ADO (Automatic Data Optimisation) => based on heat_map=ON/OFF(default) (working at CDB in this version)

  • Emergency Monitoring (is from OEM Cloud Control) with O/S credentials (check hung analysis)

  • Real-Time ADDM (regular ADDM is based on AWR Snapshots, real-time ADDM is based on ASH Data (last 10 min))

  • In-Memory introduced

  • Data Redaction (security feature, visibility masking) and it is different from Data Masking

  • Partition Enhancements (merge, split, add multiple, remove multiple, etc.)

12.1.0.2 Onwards -

  • Clone a Remote PDB or Non-CDB (12.1.0.2)

  • Metadata Only PDB Clones (12.1.0.2)

  • PDB Subset Cloning (12.1.0.2)

  • PDB CONTAINERS Clause (12.1.0.2 and 12.2)

  • PDB Logging Clause (12.1.0.2)

  • USER_TABLESPACES Clause (12.1.0.2)

12.2.0.1 Onwards -

  • Application Containers (12.2)

  • Controlling PDB Replication in Data Guard Environments : ENABLED_PDBS_ON_STANDBY Parameter (12.2)

  • Default Tablespace Clause During PDB Creation (12.2)

  • Flashback Pluggable Database (PDB) (12.2)

  • Hot Clone a Remote PDB or Non-CDB (12.2)

  • Local Undo Mode (12.2)

  • Parallel PDB Creation Clause (12.2)

  • PDB Archive Files (.pdb = xml file with data files) for Unplug and Plugin (12.2)

  • PDB Lockdown Profiles (12.2)

  • PDBs With Different Character Sets to the CDB (12.2)

  • PDB Refresh (12.2)

  • Proxy PDB (12.2)

  • Relocate a PDB (auto drop on source side) (12.2)

  • Rename Services During PDB Creation (12.2)

  • Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO)

  • Table Point in Time Recovery across Platforms

  • New Tool SQLcl, New Commands and Features for SQL * Plus

18c Onwards -

  • CDB Fleet Management

  • Copying a PDB in a Data Guard Environment

  • DBCA PDB Clone and DBCA CDB Duplicate

  • Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB)

  • PDB Lockdown Profile Enhancements

  • PDB Snapshot Carousel

  • Refreshable PDB Switchover

  • Usable Backups of Non-CDBs and Relocated PDBs

  • Logical Partitioning - Container Maps

  • Parallel Statement Queuing at the PDB Level

  • Create a Keystore for each Pluggable Database

  • PDB Snapshot Carousel

  • ADDM analysis for PDBs

  • Schema only accounts

19c Onwards -

  • DBCA PDB Remote Clone

  • DBCA PDB Relocate

  • Upgrading to Oracle Database 19c

  • Upgrading to Oracle Database 19c (Non-CDB) - Upgrade from 11.2 to 19c, including conversion to PDB.

  • Workload capture and replay in a PDB

  • Support for multiple PDB shards in the same CDB

  • Cloud object store support for Data Pump Import

  • Database Vault Operations Control for infrastructure database administrators

Thank you for taking a look. I hope this helps.


Regards,

Balaaji Dhananjayan

153 views0 comments

Recent Posts

See All

Comments


bottom of page