Oracle Database 18c: New Features for Administrators Ed 1

Suggested Prerequisite

• Knowledge of Oracle Database 11g R2 and 12c

Required Prerequisite

• Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
• Oracle Database 12c R2: New Features for Administrators Part 2
• Oracle Database 12c R2: High Availability New Features

Audience

• Database Administrators
• Database Developers

Course Topics

1. Leveraging Multitenant Enhancements

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

2. Improving Performance

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

3. Managing Security

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

4. Handling Enhancements in Big Data and Data Warehousing

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

5. 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

6. Applying General Database Enhancements

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

7. Describing Sharding Enhancements

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