Oracle - Course Details

OraD12c:MMAN Oracle Database 12c: Managing Multitenant Architecture NEW

Oracle Course Description:
During this two day course, gain a conceptual understanding of the multitenant architecture. Learn how to manage an Oracle multitenant container database and any associated pluggable databases in an effective and efficient manner.
Oracle Course Duration:
2 DAYS
Oracle Course Target Audience:
Data Warehouse Administrator,Database Administrators,Database Designers,Support Engineer,Technical Administrator
Oracle Course Prerequisite:
Knowledge of non-CDB configuration and management,Basic knowledge of Linux operating system,Working knowledge of SQL and use of PL/SQL packages,Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
Course Content:
  • 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