Oracle Database 12c: Managing Multitenant Architecture (D79128) – Outline

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