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

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

Module 1: Application Containers and Applications

• What are 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 Optimizing Joined Columns by Creating Join Groups?
• Interact with Other Products and Features

Module 15: SQL Tuning

• Enhancement of SQL Performance Analyzer
• Enhancement of SQL Plan Management
• Statistics Gathering Performance Improvements
• Optimizer Statistics Advisor
• How to do SQL Performance Analyzer (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 Materialized Views with On Query Computation?
• Describe how to Use ON STATEMENT Refresh When a DML Operation Takes Place on Materialized 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 SQL 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