All Things Database: Education, Best Practices,
Use Cases & More

Oracle University Offers New Courses Covering Oracle Database 12c Release2

Edgar Haren
Principal Product Marketing Director

          September was an exciting month for Oracle, as Oracle OpenWorld was in full swing, and new and exciting cloud services were announced to the market.  Oracle announced Oracle Database 12c Release 2 to the cloud. In addition, we also unveiled the  new cloud database offering, Oracle Database Exadata Express Cloud Service.

Figure-1: Oracle Database 12c Release 2 Designed For The Cloud

          Oracle Database 12c R2 offers several new features, as well as feature enhancements for enhanced cloud data management. Accompanying the cloud services enhancements, there are new Oracle courses offered. The Oracle Database 12c R2: New Features for 12c R1 Administrators is a comprehensive new course that will guide you through each of the new features and provides ample opportunities to discuss and explore how these features may affect your working operations. This course is the first 12c Release 2 course available in a series of learning paths being developed to get you up to speed on Oracle Database Cloud Services.  This course is ideal for current Oracle Database 12c administrators however students are also encouraged to take this class.

This course bridges the following enhancements between Oracle Database Release 1 and Release 2 and covers the following key areas:

  • Cloud lesson explains the various Oracle Database Cloud single-instance service components and their interactions.
  • Security lessons cover enhancements in auditing like role based conditional auditing, in privilege administration like new system administrative privilege for RAC, in Privilege Analysis and Data Redaction, in Transparent Sensitive Data Protection with new types of policies for FGA and TDE, and finally also in Transparent Data Encryption (TDE).
  • Availability lessons cover enhanced features in RMAN like table recovery, transport data across platforms, enhancements related to online operations, and finally ongoing enhancements with Oracle Data Pump, SQL*Loader and external tables.
  • Performance lessons explain the new features to increase the performance of the databases with SQL Performance Analyzer, DB Replay and SQL Plan Management, and to increase query execution with the Optimizer Statistics Advisor, SQL JOIN processing. You will also learn about In-Memory Column Store enhancements like In-Memory FastStart, In-Memory Expressions and Virtual Columns, and objects eviction with ADO policies.
  • Partitioning lesson covers enhancements in partitioning methods.
  • Manageability lesson covers enhancements in Database Operations.
  • Diagnosability lessons cover enhancements in ADR space management and explain what can be completed with the new Trace File Analyzer (TFA) tool.

Figure-2: Oracle Database 12c Release 2 Key Enhancements


For Oracle Database administrators trained on prior versions, you are encouraged to take:

There are a host of New Features in Oracle Database 12c R2 and the Oracle Database 12c R2: New Features for 12c R1 Administrators course will allow current Oracle Database 12c administrators an opportunity to review these features and learn how to apply them with training from the pros, as you explore Oracle Database Cloud Services.

Following new features and their benefits are covered:


  • Application Container, a new type of container in multitenant container databases (CDBs) allows you to simplify administrative tasks and improve manageability.
  • New methods for creating new pluggable databases ( PDBs):  Hot cloning, Near-zero downtime PDB relocation and Proxy PDB will enable rapid provisioning of PDBs.
  • Performance and monitoring new features provide more control over your PDBs and resource management. Some of these new features are PDB-level snapshots, SGA and PGA memory management at the PDB level.
  • A new option for unified audit policies allows users to be audited based on granted roles, resulting in increased auditing granularity.

Come learn how you can take advantage of the industry leading data management platform.  Get started by visiting education.oracle.com/database12c to find the right learning path for you!!!


Follow Us On Social Media:

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.