D93517 - Oracle Database 12c R2: New Features for 12c R1 Administrators

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.

• 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