Oracle Database 12c R2: New Features For 12c R1 Administrators Ed 1 - Canada

​Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Outline

Module 1: Application Containers and Applications

• What is Application Root and Application PDBs?
• Application Container
  • Create
  • Manage
  • Install Application
  • Patch Application
  • Upgrade Application
• Impacts in
  • Data Guard
  • Oracle Goldengate
  • Oracle Streams
  • Xstream
  • ADO
  • Heat Maps

Module 2: Security in PDBs

• Create Users in Application Containers
  • Commonly
  • Locally
• Grant Privileges in Application Containers
  • Commonly
  • Locally
• Grant Roles in Application Container
  • Commonly
  • Locally
• Differentiate
  • Common and Local Roles in Application Containers
  • Common and Local Objects in Application Containers
  • Common and Local Profiles in Application Containers
• How to Manage PDB Lockdown Profiles?
• How to Create Unified Auditing Policies Operations in Application Containers?

Module 3: PDBs Creation Using New Methods

• How to Create a PDB from CDB Seed Enhancements?
• Unplug into a PDB Archive File
• Plug Using the Archive File
• How to Create Local UNDO Tablespace at PDB Level?
• What is Hot Cloning?
• Near-Zero Downtime PDB Relocation and Create a Remote Proxy PDB

Module 4: PDBs Recovery and Flashback

• Shut Down a PDB When PDB Datafile is Missing
• Flashback at PDB Level and Flashback a PDB To a Clean PDB Restore Point

Module 5: Performance in PDBs

• View
  • CDB / PDB ADDM Analysis
• Manage
  • SGA and PGA at the PDB Level
• Share
  • Resources Between PDBs

Module 6: Upgrade and Other Operations in PDBs

• Upgrade
  • 12.1.0.2 CDB to 12.2
  • 12.1.0.2 PDB to 12.2 By Using Unplug, Plug, and Upgrade
• Use Cross-Platform Non-CDB or PDB Backup sets to Import Into a CDB

Module 7: Privileges and User Profiles

• What is New 12.2 SYSRAC Administrative Privilege?
• Enhancements of Password File
• External Users Grant Administrative Privileges
• How to Migrate the Password File from Pre-12 or 12.1 to 12.2?
• New System Privilege
  • Inherit any Remote Privileges
  • Object Privilege Inherit Remote Privileges
• Security of Administrative Users Enhancement
• How to Pre-Configure a Maximum Number of Days in the User Profile for Which a User Can Remain Inactive?

Module 8: Unified Auditing

• Audit Policies for All Users to Whom the Role is Granted Directly
  • Create Audit Policies
  • Enable Audit Policies
• How to Capture VPD (Virtual Private Database) Generated Predicates?

Module 9: Data Redaction

• EM GUI New Redaction Format Library
• Redaction Policy Expression and New Redaction Functions

Module 10: Data Encryption

• Encrypt, Decrypt, and Rekey Tablespaces Online
• Specific Tablespaces
  • SYSAUX
  • SYSTEM
  • UNDO
  • Temporary
• How to Complete the Operations with Alter Tablespace Encryption Finish Encrypt, Rekey, and Decrypt?

Module 11: Transparent Sensitive Data Protection

• Use TSDP with
  • Unified Auditing
  • Fine-Grained Auditing (FGA)
  • Transparent Data Encryption (TDE)

Module 12: Availability Enhancements

• Non-Auto-Login Support for Duplicate
  • Use Encrypted Backups Whose Decryption Keys are in a Non-Auto-Login Wallet
• Update and Drop the Catalog Without using DROP CATALOG and UPGRADE CATALOG Commands
• Automate the Two Step Manual Process into One Recovery Operation After Missing Logs Found During RECOVER DATABASE
  • Recrepair FAILURE Command
• Transport Data Across Platforms and Steps to Recover a Table
• What is Online Redefinition Supports?

Module 13: Oracle Data Pump, SQL Loader, and External Tables

• Enhancements of
  • Oracle Data Pump
  • SQL Loader
  • External Table

Module 14: In-Memory Column Store

• Dynamic Parameter in 12.2
  • INMEMORY_SIZE
• Caches Results of Virtual Columns and Frequently Evaluated Expressions For Subsequent Reuse
• How to Optimising Joined Columns by Creating Join Groups?
• Interact with Other Products and Features

Module 15: SQL Tuning

• Enhancement of SQL Performance Analyser
• Enhancement of SQL Plan Management
• Statistics Gathering Performance Improvements
  • Optimiser Statistics Advisor
• How to do SQL Performance Analyser (SPA) Enhancements to Make it Resilient to Certain Workloads Which Can Cause Divergence?
• What are the New Ways of SQL Processing?
• What are the Continuous Adaptive Query Plans?

Module 16: Resource Manager and Other Performance Enhancements

• Manage Session PGA Limit and Reduce Cursor Invalidations for DDLs
• Advanced Index Compression (HIGH)
• What are Real-Time Materialised Views with On Query Computation?
• Describe how to Use ON STATEMENT Refresh When a DML Operation Takes Place on Materialised Views Without the Need to Commit the Transaction?
• What is HCC Data Compression with ADO Row-Level Policy

Module 17: Partitioning

• Auto-List Partitioning and Composite Partitioning
• Multicolumn List Partitioning and Read-Only Partition
• Creation of Defer Subpartition Segment
• How to Filter Data During Partition Maintenance Operations?

Module 18: Manageability

• How to Start and Stop a DBOP by Specifying the Session ID and Serial#?

Module 19: Diagnosability

• Ho to Set a Retention Target to ADR for an Automatic Delete of ADR Files?
• How to Use the Retention Advisor?
• Installation of TFA Collector by Default for RDBMS (With RDBMS Root Scripts)
• Start TFA Collector
• Allow Data Pump Tracing Changes Without Stopping and then Restarting the Job
• MV Refresh Statistics

Module 20: Oracle Database Cloud Services

• What is Oracle Database Cloud Services Console?
• How to Create a Database Deployment Under 12.2?
• Procedure of Database Deployment Backup and Recovery Automatic
• Database Deployments Vs On-Premises Databases
• How to Migrate On-Premises Database to Oracle Database Public Cloud Services?

Module 21: SQL Enhancements

• What is New SQLcl Utility?
• Usage of New 128 Bytes Length for Database Objects
• How to Recall SQL*Plus Commands in the Same Session from Memory?
• How to Use the New VALIDATE_CONVERSION Function