Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

Suggested Prerequisite

• Knowledge of Oracle Database 11g R2

Required Prerequisite

• Oracle Database 12c: Install and Upgrade Workshop
• Using Oracle Enterprise Manager Cloud Control 13c Ed 2

Audience

• End Users
• Database Administrators
• Database Administrators
• System Administrator
• System Administrator

Course Topics

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. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. acking 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

9. 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

10. 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

11. 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

12. 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

13. Managing Storage

• Creating Permanent Tablespaces in a CDB
• Objects in Tablespaces
• UNDO Tablespaces
• Tablespaces Created During PDB Creation
• Temporary Tablespaces
• Defining Default Permanent Tablespaces

14. 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

15. 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

16. 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