Basics Of Multitenant Container Database (CDB)
- Benefits of the multitenant architecture
- Differences between the root container and pluggable database containers
- Structure of the root
- Structure of Pluggable Database (PDB)
- CDB_xxx and DBA_xxx views
Configuring And Creating CDB And PDBs
- Tools: DBCA and SQL*Plus
- Configuration and creation of CDB
- Exploring the Structure (CDB_xxx views and EM)
- Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express
- Create a new PDB from PDB$SEED
- Create a PDB from a non-CDB
- Clone a PDB into the same CDB or into another CDB using DB links
- Plug in an unplugged PDB
Managing CDB And PDBs
- Connect to CDB as administrator
- Connect to a PDB using a service name
- Start up a CDB
- Open / Close a PDB (SQL*Plus, srvctl, EM)
- Open / Close all PDBs
- Shut down a CDB
- Preserve or discard the PDBs open mode when the CDB restarts
- Change PDB state
Managing Tablespaces, Common And Local Users, Privileges & Roles
- Create permanent tablespaces in the root and PDBs
- Manage common and local schemas and users in the root and PDBs
- Manage system and object privileges to common and local grantees granted “commonly” or “locally”
- Manage common and local roles granted “commonly” or “locally
TManaging Backup / Recovery / Flashback
- Backup a whole CDB
- Backup a PDB
- Recover CDB from redo log files, control files, undo datafiles loss
- Recover PDB from PDB datafiles loss
- Flashback at CDB level
- Explain the two methods of migration
Online Datafile Move And Moving Data (DATAPUMP)
- Full Transportable Export/Import Overview
- Plugging a Non-CDB into CDB Using Data Pump
- Transporting a Database over the Network Example
- Disabling Logging for Oracle Data Pump Import Overview
- Exporting Views as Tables Overview
- Specifying the Encryption Password
- Compressing Tables during Import
Privileges Enhancements
- Implementing Separation of Duty for Database Administration Tasks
- Using Database Privilege Analysis
- Overview of Database Privilege Analysis
- Granting the CAPTURE_ADMIN role to enable management of privilege captures
- Creating and starting/stopping privilege captures
- Viewing privilege profile data
- Querying DBA_PRIV_CAPTURES
- Explaining the purpose of the default ORA$DEPENDENCY profile
- Common and local users, roles and privileges
- New Administrative Privileges
- New Administrative Privilege SYSBACKUP
- New Administrative Privilege SYSDG
- New Administrative Privilege SYSKM
- OS Authentication and OS Groups
- Password Authentication for SYSBACKUP
- Password Authentication for SYSDG
- New System Privilege PURGE DBA_RECYCLEBIN
Auditing Enhancements
- Overview of the Unified Audit Trail
- Enabling the Unified Audit Trail
- Creating a separate tablespace for the unified audit trail
- Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
- Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
- Creating audit policies
General RMAN New Features And FDA Enhancements
- Making Database Connections With RMAN
- Using the SYSBACKUP Privilege
- Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
- Backing up and Restoring Very Large Files
- Creating Multisection Backups
- Transporting Data Across Platforms
- Transporting Data: Processing steps
In-Memory Column Store
- In-Memory Database option goals and benefits
- Row format and columnar format
- New SGA component:
- IMCU synchronization
- Deployment and behaviors
- Compression ratio
- New dictionary tables and added columns
In-Memory Caching
- Setting up Full Database In-Memory Caching
- Using Full Database In-Memory Caching
- Explaining the two buffer replacement algorithms of Automatic Big Table Caching
- Configuring Automatic Big Table Caching.
- Using Automatic Big Table Caching
Resource Manager And Other Performance Enhancements
- Manage resources between PDBs
- Manage resources within a PDB
- Manage resources with CDB and PDBs plans
- Manage runaway queries
- Control the in-memory database repopulation resource consumption
- New Architecture: Multiprocess / MultiThread
