D93517 - Oracle Database 12c R2: New Features for 12c R1 Administrators
The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.
Learn To:
- Create and manage application containers and applications in multitenant container databases.
- Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
- Perform pluggable database flashback.
- Upgrade the multitenant container databases and pluggable databases.
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and
- Transparent Data Encryption.
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
- Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
- Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
- Monitor your databases by using DB operations enhancements.
- Benefit from enhancements in partitioning methods.
- Benefit from ADR automatic space file management.
- Use the Trace File Analyzer collector to diagnose issues.
- Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
- Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
- Describe the Oracle Public Cloud services related to databases management.
Upon completing this course, the learner will be able to meet these overall objectives:
- Perform recovery and flashback operation on pluggable databases
- Monitor multitenant container database and pluggable databases by using ADDM / AWR enhancements at PDB level
- Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles
- Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing
- Benefit from enhancements in partitioning methods
- Use the ADR automatic file space management
- Use the SQLcl new utility as the new SQL command line interface
- Create pluggable databases with new methods and local UNDO mode
- Create and manage application containers and applications in multitenant container databases
- Manage security in application containers
- Manage data optimization in pluggable databases with heat map statistics and ADO policy eviction
- Upgrade pluggable databases and multitenant container databases
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection &
- Data Encryption
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements and by performing online operations
- Monitor your databases by using DB operations
- Increase the SQL performance by using In-Memory Column-Store enhancements for deployment and SQL performance
- Database Administrators
- System Administrator
- Support Engineer
- Technical Consultant
- Module 1: Introduction
- Module 2: Application Containers and Applications
- Module 3: Security in PDBs
- Module 4: PDBs Creation Using New Methods
- Module 5: PDBs Recovery and Flashback
- Module 6: Performance in PDBs
- Module 7: Upgrade and Other Operations in PDBs
- Module 8: Privileges and User Profiles
- Module 9: Unified Auditing
- Module 10: Data Redaction
- Module 11: Data Encryption
- Module 12: Transparent Sensitive Data Protection
- Module 13: Availability Enhancements
- Module 14: Oracle Data Pump, SQL*Loader and External Tables
- Module 15: In-Memory Column Store
- Module 16: SQL Tuning
- Module 17: Resource Manager and Other Performance Enhancements
- Module 18: Partitioning
- Module 19: Manageability
- Module 20: Diagnosability
- Module 21: Oracle Database Cloud Services
- Module 22: SQL Enhancements
- Knowledge of Oracle Database 12c and particularly 12.1.0.2
- Oracle Database 12c R1: New Features for Administrators Ed 2
Suggested Prerequisites:
- Oracle Database 12c: Install and Upgrade Workshop
- Using Oracle Enterprise Manager Cloud Control 12c Ed 2
This course is not associated with any Certification.