Oracle 12c: New Features

Explore the top new Oracle 12c features and enhancements that DBAs should know about.

Introduction

• Welcome
• What you need to know
• Exercise files

1. Oracle 12c Multitenant Architecture

• DB consolidation and multitenancy needs
• Pre-12c: Dedicated servers
• Pre-12c: Instance consolidations
• Pre-12c: Schema consolidations
• Oracle 12c multitenant core concepts
• Multitenant Container Database (CDB)
• The CDB architecture
• The root container
• Pluggable databases (PDBs)
• The SEED PDB and PDB cloning
• Enable the Oracle 12c CDB architecture
• Connect to the CDB
• Create, connect, and drop PDBs
• PDB portability between different CDBs
• Unplug a PDB
• Clone a PDB
• Use of the new data dictionary views
• Local and common users concepts
• Create a local user in a PDB
• Create a common user in cdb$root

2. Oracle 12c In-Memory Database

• Row and columnar format differences
• In-memory column store architecture
• Enable and size the In-Memory Column Store
• Choose the objects to be cached in-memory
• Create the demo environment
• Load tables to In-Memory Column Store
• Configure in-memory data pre-caching
• Configure in-memory data compression
• Identify tables using in-memory
• Verify queries using in-memory
• Control query access to in-memory

3. Create the Demo Environment

• Create the DEMO_PDB for exercises

4. Improved Column Default Values

• Overview of default column values
• Use default column values with sequence
• Use default column values with identity

5. Increased Size Limits for VARCHAR Data Types

• Enable extended 32K VARCHARs
• Use extended 32K VARCHARs

6. Improved "Top-n" Queries

• Explore Top-N queries & Pagination
• Fetch the Top-N Rows from a Table

7. Partitioning Features

• Move partitions online
• Asynchronous global index maintenance
• Partial indexes

8. Adaptive Execution Plans

• What are adaptive execution plans?
• Use adaptive execution plans

9. Temporary Undo

• What is temporary undo?
• Enable and use temporary undo

10. RMAN Backup and Recovery

• Backups in a multitenant database
• Backup the CDB and PDB
• New SYSBACKUP permission
• Support for SQL commands and extended report schema
• Restore an individual pluggable database
• Restore a single table to point in time

Conclusion

• Next steps