Surf through this page to know about features and enhancements that were released on each version from 12cR1. 

​

12.1.0.1 Onwards -

​

1. Create and Configure a Container Database (CDB)

2. Create and Configure a Pluggable Database (PDB)

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

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

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

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

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

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

9. Flashback of a Container Database (CDB)

10. Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB)

11. RMAN (BACKUP VALIDATE, RESTORE VALIDATE, RECOVERY VALIDATE)

12. Database Triggers on Pluggable Databases (PDBs)

13. Transparent Data Encryption (TDE) in Pluggable Databases (PDBs)

14. PDBs With Different Time Zones to the CDB

15. Pluggable Database (PDB) Names Modify

16. Upgrade a PDB using Unplug/Plugin

17. Recovery Manager (RMAN) Database Duplication Enhancements : Multitenant Considerations

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

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

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

21. In-Memory introduced

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

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

 

12.1.0.2 Onwards -

​

1. Clone a Remote PDB or Non-CDB (12.1.0.2)

2. Metadata Only PDB Clones (12.1.0.2)

3. PDB Subset Cloning (12.1.0.2)

4. PDB CONTAINERS Clause (12.1.0.2 and 12.2)

5. PDB Logging Clause (12.1.0.2)

6. USER_TABLESPACES Clause (12.1.0.2)

​

12.2.0.1 Onwards -

 

1. Application Containers (12.2)

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

3. Default Tablespace Clause During PDB Creation (12.2)

4. Flashback Pluggable Database (PDB) (12.2)

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

6. Local Undo Mode (12.2)

7. Parallel PDB Creation Clause (12.2)

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

9. PDB Lockdown Profiles (12.2)

10. PDBs With Different Character Sets to the CDB (12.2)

11. PDB Refresh (12.2)

12. Proxy PDB (12.2)

13. Relocate a PDB (auto drop on source side) (12.2)

14. Rename Services During PDB Creation (12.2)

15. Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimisation (ADO)

16. Table Point in Time Recovery across Platforms

17. New Tool SQLcl, New Commands and Features for SQL * Plus

​

18c Onwards -

​

1. CDB Fleet Management

2. Copying a PDB in a Data Guard Environment

3. DBCA PDB Clone and DBCA CDB Duplicate

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

5. PDB Lockdown Profile Enhancements

6. PDB Snapshot Carousel

7. Refreshable PDB Switchover

8. Usable Backups of Non-CDBs and Relocated PDBs

9. Logical Partitioning - Container Maps

10. Parallel Statement Queuing at the PDB Level

11. Create a Keystore for each Pluggable Database

12. PDB Snapshot Carousel

13. ADDM analysis for PDBs

14. Schema only

​

​

19c Onwards -

​

1. DBCA PDB Remote Clone

2. DBCA PDB Relocate

3. Upgrading to Oracle Database 19c

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

5. Workload capture and replay in a PDB

6. Support for multiple PDB shards in the same CDB

7. Cloud object store support for Data Pump Import

8. Database Vault Operations Control for infrastructure database administrators

​

​

​