Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1

Duration : 5 Days (40 Hours)

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Overview:

The Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 course delivers a comprehensive exploration of the latest enhancements introduced in Oracle Database 12c Release 2 (12.2). Participants engage with architectural insights, installation, configuration of novel features, and hands-on labs, coupled with administration best practices. The curriculum delves into crucial aspects of the multitenant architecture, encompassing multitenant environments, Automatic Data Optimization, Data Living Archive, and other key elements. Learners acquire proficiency in creating and managing multitenant databases, configuring and optimizing Automatic Data Optimization, working with JSON documents, and more. Geared towards administrators, developers, and DBAs seeking in-depth knowledge of advanced Oracle Database 12c Release 2 features, this course empowers participants to leverage the latest capabilities effectively.

Intended Audience:

  • Database Administrators (DBAs) working with Oracle Database 12c R1
  • Experienced DBAs looking to upgrade their skills and knowledge to Oracle Database 12c R2
  • IT Professionals responsible for managing and administering Oracle databases
  • Database Architects seeking to understand and implement the new features introduced in Oracle Database 12c R2
  • System Analysts and Technical Consultants involved in database administration and management.

Learning Objectives of Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1:

1. Describe the new features in Oracle Database 12c R2, such as pluggable databases, multitenant architecture, and memory optimization.
2. Describe the new database administration options available in Oracle Database 12c R2.
3. Manage database performance, scalability, and availability using the new Oracle Database 12c R2 performance tuning components.
4. Navigate the Unified Auditing and Oracle Data Redaction features of Oracle Database 12c R2.
5. Protect sensitive data using Oracle Database Vault and Transparent Data Encryption.
6. Configure and troubleshoot Oracle Database 12c R2 Network Encryption technology.
7. Implement changes to a database and database environment using Oracle Database 12c R2’s Data Pump, Recovery Manager, and Golden Gate features.
8. Exploit the benefits of Oracle Database 12c R2’s database consolidation capabilities.
9. Utilize the Oracle Database 12c R2 database and partitioning features to efficiently store and manage data.
10. Possess the skills necessary for successful Oracle Database 12c R2 database administration.

 Module 1: Introduction

  • Global objectives of the course
  • Lessons grouped by area
  • Schedule of the wee

 Module 2: Application Containers and Applications

  • Application root and application PDBs
  • Create and manage an application container
  • Install application in an application container
  • Patch application
  • Upgrade application
  • Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map

 Module 3: Security in PDBs

  • Create users commonly, locally in application containers
  • Grant privileges commonly, locally in application containers
  • Difference between common and local roles in application containers
  • Grant roles commonly, locally in application containers
  • Difference between common and local objects in application containers
  • Difference between common and local profiles in application containers
  • Manage PDB lockdown profiles
  • Create unified auditing policies operations in application containers

 Module 4: PDBs Creation Using New Methods

  • Create a PDB from CDB seed enhancements
  • Unplug into a PDB archive file and plug using the archive file
  • Create a local UNDO tablespace at PDB level
  • Hot cloning
  • Near-zero downtime PDB relocation
  • Create a remote proxy PDB

 Module 5: PDBs Recovery and Flashback

  • Shut down a PDB when an essential PDB datafile is missing
  • Flashback at PDB level
  • Flashback a PDB to a clean PDB restore point

 Module 6: Performance in PDBs

  • View CDB / PDB ADDM analysis
  • Manage SGA and PGA at the PDB level
  • Share resources between PDBs

 Module 7: Upgrade and Other Operations in PDBs

  • Upgrade a CDB to 12.2
  • Upgrade a PDB to 12.2 by using unplug / plug / upgrade
  • Use cross-platform non-CDB or PDB backupsets to import into a CDB

 Module 8: Privileges and User Profiles

  • New 12.2 SYSRAC administrative privilege
  • Password file enhancements
  • Grant administrative privileges to external users
  • Migrate the password file from pre-12 or 12.1 to 12.2
  • New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
  • Enhance the security of administrative users
  • Pre-configure a maximum number of days in the user profile for which a user can remain inactive

 Module 9: Unified Auditing

  • Create and enable audit policies for all users to whom the role is granted directly
  • Capture VPD (Virtual Private Database) generated predicates

 Module 10: Data Redaction

  • New redaction format library in EM GUI
  • Redaction policy expression
  • New redaction functions

 Module 11: Data Encryption

  • Encrypt / decrypt / rekey tablespaces online
  • Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary

 Module 12: Transparent Sensitive Data Protection

  • Use TSDP with Unified Auditing
  • Use TSDP with Fine-Grained Auditing (FGA)
  • Use TSDP with Transparent Data Encryption (TDE)

 Module 13: 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 entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / D
  • Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Re
  • REPAIR FAILURE command
  • Transport Data Across Platforms
  • Steps to recover a table
  • Describe online redefinition supports

 Module 14: Oracle Data Pump, SQL*Loader and External Tables

  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • External table enhancements

 Module 15: In-Memory Column Store

  • Dynamic parameter in 12.2 : INMEMORY_SIZE
  • Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
  • Optimizing joined columns by creating join groups
  • Interaction with other products, features

 Module 16: SQL Tuning

  • SQL Performance Analyzer enhancements
  • SQL Plan Management enhancements
  • Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
  • SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
  • New ways of SQL processing
  • Continuous Adaptive Query Plans

 Module 17: Resource Manager and Other Performance Enhancements

  • Manage session PGA limit
  • Reduce Cursor Invalidations for DDLs
  • Describe the Advanced Index Compression (HIGH)
  • Define real-time materialized views with on query computation
  • Use ON STATEMENT refresh when a DML operation takes place on materialized views without the need to committhe transacti
  • Describe HCC data compression with ADO row-level policy

 Module 18: Partitioning

  • Explain auto-list partitioning
  • Composite partitioning
  • Explain multicolumn list partitioning
  • Read-only partition
  • Defer subpartition segment creation
  • Filter data during partition maintenance operations

 Module 19: Manageability

  • Start / stop a DBOP by specifying the Session ID and Serial#

 Module 20: Diagnosability

  • Set a retention target to ADR for an automatic delete of ADR files
  • Use the retention advisor
  • Install TFA Collector by default for RDBMS (with RDBMS root scripts)
  • Start TFA Collector
  • Allow Data Pump tracing to be changed without stopping and then restarting the job
  • MV refresh statistics

 Module 21: Oracle Database Cloud Services

  • Describe the Oracle Database Cloud Services console
  • Create a database deployment under 12.2
  • Database deployment backup and recovery automatic procedures
  • Differences between database deployments and on-premises databases
  • Migrate on-premises database to Oracle Database Public Cloud Services

 Module 22: SQL Enhancements

  • Describe the new SQLcl utility
  • Use new 128 bytes length for database objects
  • Recall SQL*Plus commands in the same session from memory
  • Use the new VALIDATE_CONVERSION function

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Prerequisites:

This Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Training course assumes that students have experience with Oracle Database 12c Release 1 features and functions. Specifically, included in this pre-requisite understanding should include topics such as:
• Installing and configuring an Oracle Grid Infrastructure
• Implementing and managing Oracle Database 12c
• Managing database solutions by using performance, tuning, and Program Global Area (PGA) optimization
• Creating fast-recovery solutions
• Configuring and managing Oracle Net Services
• Managing resources by using Resource Manager and Database Resource Manager
• Implementing security features
• Creating and managing database objects
• Using Recovery Manager for backup and recovery
• Implementing Data Pump for secure and efficient data movement
• Creating Oracle Flashback Database, SQL Tuning Advisor and Automatic Database Diagnostic Monitor
• Implementing Oracle Database Application Performance Tuning
• Database Performance Tuning using ASH & AWR
• Configuring and using Oracle Audit Vault
• Using Flashback Log /Flashback Table/ Flashback Transaction
• Implementing Oracle Database 12c security features
• Setting up and Managing Oracle Multitenant
• Managing Resources Using Multitenant
• Installing and Configuring Oracle Database Resource Manager
• Backup and Recovery for Multitenant
• And more.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.