Course Content
- 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
- 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
- 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
- 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
- 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
- Query inlined external tables and manage in-memory external tables
- Use analytic view new query capabilities
- Create and use polymorphic table functions
- 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