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