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

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

Overview

Duration: 5 Days

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.

Objectives

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
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
N/A
  • 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
Course ID:
D93517


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.