1. Introduction
Understanding DB architectures
Diagnosing database problems
Global objectives of the course
Schedule of the week
Using SQL new features and tools
Lessons grouped by modules
2. Using SQL New Features and SQLcl
Use SQL row-limiting clause
Use new 128 bytes identifier length for database objects
Describe the support for invisible and hidden columns
Increase length limits of data types
Use the new VALIDATE_CONVERSION function
Recall SQL*Plus commands in the same session from history
Describe the new SQLcl utility
3. Understanding CDB Basics
Challenges
Configurations
CDB root and pluggable database containers
SYSTEM objects in the USER container
New Multitenant Architecture: Benefits
Non-CDB Architecture vs Oracle Multitenant Container Database
A pristine installation
Provisioning a pluggable database
4. Creating CDB and Regular PDBs
Tools
Create a CDB using new clauses
What's new in CDB after CDB creation
ADR
Data dictionary views
Provisioning new PDBs: overview
What to do in CDB after CDB creation
5. Creating Application PDBs and Installing Applications
PDBs and applications
Application common objects
Create and manage an application container
Types of containers
Patch and upgrade applications
Regular PDBs vs application PDBs
Application containers
Install applications
6. Creating PDBs
Cloning regular and application containers PDBs
Converting regular PDBs to application root or PDBs
Cross-Platform transportable PDB
Plugging unplugged regular and application PDBs into CDB
Plugging unplugged PDBs with encrypted data
Perform hot cloning and relocation
Configure and use locla UNDO mode
Plugging or cloning a non-CDB into a CDB
7. Managing CDB and PDBs
Creating and renaming Services
Switching Connection
Opening CDBs and PDBs
Managing CDB and PDBs
Mounting a CDB
Evaluating the impact of parameter value changes
Changing the different modes and settings of PDBs
Starting Up a CDB Instance
8. Managing Storage
Creating Permanent Tablespaces in a CDB
Objects in Tablespaces
UNDO Tablespaces
Tablespaces Created During PDB Creation
Temporary Tablespaces
Defining Default Permanent Tablespaces
9. Managing Security
Enabling Common Users to Access Data in PDBs
Encrypting data in PDBs
Creating common users, roles and profiles in CDB and PDBs
Protecting data with Database Vault policies in CDB and PDBs
Common objects in Application PDBs and operations on Data-Linked objects
Granting privileges commonly in CDB and PDBs
Auditing users in CDB and PDBs
Managing PDB lockdown profiles
10. Backing up, Recoverying and Flashing Back
Instance failure and instance recovery
CDB and PDB backups
PDB point-in-time recovery
New syntax and clauses in RMAN
PDB tempfile, essential and non-SYSTEM tablespaces recovery
CDB and PDB flashback
Duplicating PDBs
Using RMAN backup to plug an unplugged PDB
11. Managing Performance
Monitoring PDB memory usage
AWR report
Managing SGA and PGA for PDBs
Controlling the Degree of Parallelism of Queries
PDB-Level snapshot views
AWR and ADDM behaviour at CDB and PDB levels
Sizing the CDB
Tuning a CDB
12. Managing Resources Allocation
Controlling PDB IO rate limit
Managing resources within a PDB
CDB Resource plan basics: Limits + cpu_count init parm per PDB
Creating and setting PDB performance profiles
Allocating resources in the CDB and PDBs
Managing resources between PDBs
13. Moving and Migrating Data
Transporting a database over the network
Exporting non-CDB data and importing non-CDB data into PDB
Using SQL*Loader with PDBs
Exporting and importing between PDBs
Exporting from PDB and importing into a non-CDB
Full Transportable export/import
Using Oracle Data Pump with PDBs
14. Performing Miscellaneous Operations
Using catcon.pl utility to install/remove options from CDB/PDB
Jobs coordinator and resources
Creating a standby of a CDB
Using Xstreams with a CDB and PDB
Mining statements of a PDB using LogMiner
Scheduling operations in a PDB
15. Understanding Database Sharding
Benefits of Sharding
Advantages of Oracle Sharding over NoSQL
Creating Sharded Tables
Sharded Table Family
What Is Database Sharding?
Application Considerations for Sharding
Components of Database Sharding
Complete Deployment of a System-Managed SDB
16. Diagnosing Database Problems
TFA Collector utility
Tracing Data Pump
New ADRCI Command
Automatic Diagnostic Repository
MVs refreshed statistics history
Trace File Analyzer (TFA) Collector process and repository
ADR Retention
Network Performance
Understanding DB architectures
Diagnosing database problems
Global objectives of the course
Schedule of the week
Using SQL new features and tools
Lessons grouped by modules
2. Using SQL New Features and SQLcl
Use SQL row-limiting clause
Use new 128 bytes identifier length for database objects
Describe the support for invisible and hidden columns
Increase length limits of data types
Use the new VALIDATE_CONVERSION function
Recall SQL*Plus commands in the same session from history
Describe the new SQLcl utility
3. Understanding CDB Basics
Challenges
Configurations
CDB root and pluggable database containers
SYSTEM objects in the USER container
New Multitenant Architecture: Benefits
Non-CDB Architecture vs Oracle Multitenant Container Database
A pristine installation
Provisioning a pluggable database
4. Creating CDB and Regular PDBs
Tools
Create a CDB using new clauses
What's new in CDB after CDB creation
ADR
Data dictionary views
Provisioning new PDBs: overview
What to do in CDB after CDB creation
5. Creating Application PDBs and Installing Applications
PDBs and applications
Application common objects
Create and manage an application container
Types of containers
Patch and upgrade applications
Regular PDBs vs application PDBs
Application containers
Install applications
6. Creating PDBs
Cloning regular and application containers PDBs
Converting regular PDBs to application root or PDBs
Cross-Platform transportable PDB
Plugging unplugged regular and application PDBs into CDB
Plugging unplugged PDBs with encrypted data
Perform hot cloning and relocation
Configure and use locla UNDO mode
Plugging or cloning a non-CDB into a CDB
7. Managing CDB and PDBs
Creating and renaming Services
Switching Connection
Opening CDBs and PDBs
Managing CDB and PDBs
Mounting a CDB
Evaluating the impact of parameter value changes
Changing the different modes and settings of PDBs
Starting Up a CDB Instance
8. Managing Storage
Creating Permanent Tablespaces in a CDB
Objects in Tablespaces
UNDO Tablespaces
Tablespaces Created During PDB Creation
Temporary Tablespaces
Defining Default Permanent Tablespaces
9. Managing Security
Enabling Common Users to Access Data in PDBs
Encrypting data in PDBs
Creating common users, roles and profiles in CDB and PDBs
Protecting data with Database Vault policies in CDB and PDBs
Common objects in Application PDBs and operations on Data-Linked objects
Granting privileges commonly in CDB and PDBs
Auditing users in CDB and PDBs
Managing PDB lockdown profiles
10. Backing up, Recoverying and Flashing Back
Instance failure and instance recovery
CDB and PDB backups
PDB point-in-time recovery
New syntax and clauses in RMAN
PDB tempfile, essential and non-SYSTEM tablespaces recovery
CDB and PDB flashback
Duplicating PDBs
Using RMAN backup to plug an unplugged PDB
11. Managing Performance
Monitoring PDB memory usage
AWR report
Managing SGA and PGA for PDBs
Controlling the Degree of Parallelism of Queries
PDB-Level snapshot views
AWR and ADDM behaviour at CDB and PDB levels
Sizing the CDB
Tuning a CDB
12. Managing Resources Allocation
Controlling PDB IO rate limit
Managing resources within a PDB
CDB Resource plan basics: Limits + cpu_count init parm per PDB
Creating and setting PDB performance profiles
Allocating resources in the CDB and PDBs
Managing resources between PDBs
13. Moving and Migrating Data
Transporting a database over the network
Exporting non-CDB data and importing non-CDB data into PDB
Using SQL*Loader with PDBs
Exporting and importing between PDBs
Exporting from PDB and importing into a non-CDB
Full Transportable export/import
Using Oracle Data Pump with PDBs
14. Performing Miscellaneous Operations
Using catcon.pl utility to install/remove options from CDB/PDB
Jobs coordinator and resources
Creating a standby of a CDB
Using Xstreams with a CDB and PDB
Mining statements of a PDB using LogMiner
Scheduling operations in a PDB
15. Understanding Database Sharding
Benefits of Sharding
Advantages of Oracle Sharding over NoSQL
Creating Sharded Tables
Sharded Table Family
What Is Database Sharding?
Application Considerations for Sharding
Components of Database Sharding
Complete Deployment of a System-Managed SDB
16. Diagnosing Database Problems
TFA Collector utility
Tracing Data Pump
New ADRCI Command
Automatic Diagnostic Repository
MVs refreshed statistics history
Trace File Analyzer (TFA) Collector process and repository
ADR Retention
Network Performance
