Detailed Course Outline
Introduction
- Course Objectives
- Course Schedule
- Tools
Container and Pluggable Database Architecture
- Challenges and Benefits
- Multitenant Architecture
- Provisioning PDBs
- Terminology
CDB and PDB Creation
- Using Tools
- Configuring and Creating a CDB
- Creating PDBs
- Dropping PDBs
- Migrating PDBs
Managing a CDB and PDBs
- Connection
- Managing a CDB and PDBs
- Managing PDBs Open Mode and Settings
- Configuring CDB and PDBs Initialization Parameters
Managing Storage in a CDB and PDBs
- Managing Permanent Tablespaces in CDB and PDBs
- Managing Temporary Tablespaces in CDB and PDBs
Managing Security in a CDB and PDBs
- Managing Common and Local Users
- Managing Common and Local Privileges
- Managing Common and Local Roles
- Understanding Shared and Non-Shared Objects
- Managing Common and Local Profiles
Managing Availability
- Managing Backups
- Managing Recovery Operations
- Managing Flashback Database
- Duplicating PDBs
- Special Situations and Views
Managing Performance
- Managing Performance
- Managing Resource Allocation
- Maximizing Consolidated Database Replay
Miscellaneous
- Exporting and Importing Data
- Loading Data
- Auditing Operations
- Scheduling Jobs
- Using Other Products