Oracle Database 12c: New Features for Administrators

IT/Networking/Server/Operating Systems
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This Oracle Database 12c: New Features for Administrators training class teaches the major major new features of the Oracle 12c database of interest to database and other enterprise administrators.

The primary target audiences for this textbook is database administrators, storage administrators, system administrators, implementation specialists, and data center support engineers.


  1. Learn about enhancements to the administration framework of the database, including the Enterprise Manager Cloud Control, Enterprise Manager Database Express and SQL Developer database administration capabilities.
  2. Learn enhancements to the security framework of the database, including unified auditing, fine-grained super administrator privileges, data redaction and privilege analysis.
  3. Learn to expand performance options such as in-memory columnar storage, the in-memory database option and big table caching.
  4. Learn performance monitoring enhancements, such as database operation monitoring, emergency monitoring, and real-time ADDM.
  5. Learn database consolidation using consolidated databases (cDBs) consisting of dozens or even hundreds of pluggable databases (pDBs).
  6. Learn advanced database storage options such as advanced compression, enhanced columnar compression and online movement of objects.
  7. Learn advanced compression techniques for tables and indexes.
  8. Learn about columnar vs. row-oriented database storage and the use of hybrid columnar compression.
  9. Learn heat map tracking of segment access to measure hot, warm and cold areas of the database that could be targeted for optimization.
  10. Learn iLM data management and support for that framework with available features of the Oracle database.
  11. Learn automatic data optimization and policies that automatically implement the ILM concepts of row-level compression tiering, segment-level compression tiering and segment-level storage tiering.
  12. Learn to implement custom ILM storage management policies.
  13. Learn about in-memory storage of database objects, including big table caching, full database caching and in-memory column stores.
  14. Learn to archive inactive data inside the database while not degrading performance while limiting added storage costs.
  15. Learn to introduce temporal validity into a table and perform flashback query operations using temporal validity criteria.
  16. Learn about data redaction that allows data privacy policies to be dynamically enforced during queries.

  1. Oracle 12c and The Database Utilities
    1. About Oracle 12c
    2. Oracle 12c Universal Installer
    3. EM Cloud Control
    4. EM Database Express
    5. EM Database Express Framework and XML DB
    6. Access EM Database Express
    7. SQL Developer
    8. Instance Threaded Mode
    9. Invisible Columns
  2. Database Security Enhancements
    1. Database Security Principles
    2. Database Privilege Changes
    3. Database Role Changes
    4. User Password Complexity
    5. Privilege Analysis
    6. Auditing Modes and Unified Auditing
    7. Configuring Unified Auditing and Enabling Policies
    8. Viewing and Maintaining The Audit Trail
  3. ADR and Network Enhancements
    1. Fault Diagnosability Infrastructure
    2. Advanced Network Compression
  4. Performance Improvements
    1. SQL Statement Execution
    2. Real-Time Operation Monitoring
    3. Real-Time ADDM Analysis
    4. Emergency Monitoring
    5. Real-Time ADDM
  5. Fundamentals: The Multitenant Database Architecture
    1. Cloud Computing Principles
    2. Peering Into The Architecture
    3. Multitenant Database Instance
    4. Multitenant Storage Architecture
    5. Multitenant Data Dictionary
    6. Benefits of The Architecture
    7. Challenges of The Architecture
  6. Fundamentals: Creating and Connecting to Multitenant Databases
    1. About cDB Capacity Planning
    2. cDB and pDB Creation
    3. Using Oracle Installer
    4. Using DBCA
    5. cDB and pDB Connections
    6. Using SQL*Plus
    7. EM Cloud Control
  7. Fundamentals: Multitenant Database Security Management
    1. Multitenant Security Model
    2. Multitenant Privileges and Roles
    3. Common Users
    4. Local Users
    5. Common and Local Roles and Privileges
    6. Commonly and Locally Defined
    7. Commonly and Locally Granted
    8. Common and Local Profiles
    9. Common and Local Dictionary Access
    10. Multitenant Unified Auditing
    11. Local Audit Policies
    12. Querying The Unified Audit Trail
    13. Common Audit Policies
    14. Auditing Management with EM CC
  8. Provisioning: Provisioning pDBs From pdb$seed
    1. Provision and Decommission pDBs
    2. EM CC Provisioning Prerequisites
    3. pDB File Location Prerequisites
    4. Provision A pDB From pdb$seed
    5. Provision Using SQL
    6. Provision Using EM CC
    7. Post Provisioning Checklist
    8. Drop A pDB
    9. Querying cDB and pDB Metadata
  9. Provisioning: Additional pDB Provisioning
    1. Clone A pDB
    2. Unplug and Plug-In A pDB
    3. Migrate A Non-cDB To A pDB
    4. pDB Provisioning Using EM CC
    5. pDB Provisioning Using DBCA
  10. Administration: Administering Multitenant Databases
    1. About Multitenant Administration
    2. cDB Administration
    3. cdb$root Administration
    4. pDB Administration
  11. Administration: Multitenant Storage Management
    1. Manage Permanent Tablespaces
    2. Manage Temporary Tablespaces
  12. Administration: Multitenant Backup and Recovery
    1. Devising Multitenant Recovery Plan
    2. RMAN Multitenant Usage
    3. RMAN Multitenant Backup
    4. EM CC Multitenant Backup
    5. RMAN Multitenant Recovery
    6. Complete Recovery
    7. Incomplete cDB / pDB Point-in-time
  13. Recovery (PITR)
    1. Incomplete Table Point-in-time Recovery (PITR)
    2. Multitenant Flashback Database
    3. EM CC Multitenant Recovery
    4. Multitenant Database Duplication
    5. cDB Duplication
    6. pDB Duplication
  14. Administration: Multitenant Resource Management
    1. About Resource Management
    2. cDB Resource Plans and Directives
    3. pDB Resource Plans and Directives
  15. Advanced Compression
    1. About Compression
    2. Table Compression
    3. Basic Table Compression
    4. Advanced Row Compression
    5. Additional Table Compression
  16. Considerations
    1. Index Compression
    2. Key Compression
    3. Advanced Index Compression
    4. Hybrid Columnar Compression
    5. Compression Analysis
    6. Using SQL Metadata Queries
    8. Using EM CC
  17. Heat Map Tracking and Automatic Data Optimization (ADO)
    1. About ILM
    2. The Oracle Database and ILM Support
    3. Heat Map Tracking
    4. Automatic Data Optimization (ADO)
    5. Adding ADO Policies Using SQL
    6. Managing ADO Policies Using SQL
    7. Managing ADO Policy Evaluation
    8. Managing ADO Policies Using EM CC
  18. In-Memory Storage
    1. About Traditional Table Caching
    2. Big Table Caching
    3. Full Database Caching
    4. In-Memory Column Store
    5. IMCS Internals
    6. Configuring The IMCS
    7. Assigning Objects To The IMCS
    8. Assigning Columns To The IMCS
    9. Monitoring IMCS Using EM CC
  19. In-Database Archiving
    1. About In-Database Archiving
    2. In-Database Archival Tables
    3. In-Database Archiving of Rows
    4. Temporal Validity
  20. Data Redaction
    1. About Data Redaction
    2. The Redaction Functions
    3. Using Function Type dbms_redact.random
    4. Using Function Type dbms_redact.partial
    5. Function Type dbms_redact.partial
  21. Shortcuts
    1. Using Function Type dbms_redact.regexp
    2. Function Type dbms_redact.regexp
  22. Shortcuts
    1. Defining Redaction Policies
    2. Managing Redaction Policies
    3. Customizing Full Redaction
    4. Viewing Redaction Metadata
    5. Using EM Cloud Control
    6. Inference Attacks

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.


Class Prerequisites

Experience in the following is required for this Oracle class:

  • Extensive experience working with the as a database or other administration specialist.

Course Setup
  • Live Online: Course Setup | WebEx Setup