Course Content



    Leveraging Multitenant Enhancements

  • Manage application PDBs fleet
  • Manage PDB snapshots carousel
  • Benefit from dynamic container map
  • Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
  • Use refreshable copy PDB switchover

  • Managing Security

  • Create and use a schema only account
  • Isolate PDB keystores
  • Export and import database links
  • Configure encryption of sensitive data in Database Replay files
  • Explain direct Active Directory Services integration

  • Using RMAN Enhancements

  • Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
  • Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
  • Applying General Database Enhancements

  • Manage private temporary tables
  • Use the new Data Pump Import option of the DATA_OPTIONS parameter
  • Online modification of partitioning and subpartitioning strategy
  • Merging of partitions and subpartitions online
  • Generate batched DDL by using DBMS_METADATA_DIFF package

  • Improving Performance

  • Configure Automatic In-Memory
  • Use IMEs window capture
  • Describe the new SQL Tuning Set package
  • Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation

  • Handling Enhancements in Big Data and Data Warehousing

  • Query inlined external tables and manage in-memory external tables
  • Use analytic view new query capabilities
  • Create and use polymorphic table functions

  • Describing Sharding Enhancements

  • Describe the user-defined sharding method
  • Understand support for PDBs as shards
  • Describe Oracle GoldenGate enhancements for Oracle Sharding support
  • Query system objects across shards
  • Describe improved multi-shard query enhancements

Query Form