Home > Vendors > IBM > CM22G

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

Overview

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

Content

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

Audience

  • Database Administrators
  • System Administrator
  • Support Engineer
  • Technical Consultant

Prerequisites

  • 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

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: