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
- Grant Privileges in Application Containers
- Grant Roles in Application Container
- 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
- Manage
- SGA and PGA at the PDB Level
- Share
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
- 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