The primary target audiences for this textbook are:

• Database administrators
• Storage administrators
  
• System administrators
• Implementation specialists
• Data center support engineers

In order to fully benefit from this textbook one must have extensive experience working with the Oracle 11g release as a database or other administration specialist.

• Enhancements to the administration framework of the database, including the Enterprise Manager Cloud Control, Enterprise Manager Database Express and SQL Developer database administration capabilities.
• Enhancements to the security framework of the database, including unified auditing, fine-grained super administrator privileges, data redaction and privilege analysis.
• Expanded performance options such as in-memory columnar storage, the in-memory database option and big table caching.
• Performance monitoring enhancements, such as database operation monitoring, emergency monitoring and real-time ADDM.
• Database consolidation using consolidated databases (cDBs) consisting of dozens or even hundreds of pluggable databases (pDBs).
• Advanced database storage options such as advanced compression, enhanced columnar compression and online movement of objects.
• Advanced compression techniques for tables and indexes.
• Columnar vs. row-oriented database storage and the use of hybrid columnar compression.
• Heat map tracking of segment access to measure hot, warm and cold areas of the database that could be targeted for optimization.
• ILM data management and support for that framework with available features of the Oracle database.
• 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.
• Implementing custom ILM storage management policies.
• In-memory storage of database objects, including big table caching, full database caching and in-memory column stores.
• Archiving inactive data inside the database while not degrading performance while limiting added storage costs.
• Introduce temporal validity into a table and perform flashback query operations using temporal validity criteria.
• Data redaction that allows data privacy policies to be dynamically enforced during queries.

• About Oracle 12c
• Oracle 12c Universal Installer
• EM Cloud Control
• EM Database Express
• EM Database Express Framework & XML DB
• Access EM Database Express
• SQL Developer
• Instance Threaded Mode
• Invisible Columns

• Database Security Principles
• Database Privilege Changes
• Database Role Changes
• User Password Complexity
• Privilege Analysis
• Auditing Modes & Unified Auditing
• Configuring Unified Auditing & Enabling Policies
• Viewing & Maintaining The Audit Trail

• Fault Diagnosability Infrastructure
• Advanced Network Compression

• SQL Statement Execution
• Real-Time Operation Monitoring
• Real-Time ADDM Analysis
• Emergency Monitoring
• Real-Time ADDM

• Cloud Computing Principles
• Peering Into The Architecture
• Multitenant Database Instance
• Multitenant Storage Architecture
• Multitenant Data Dictionary
• Benefits Of The Architecture
• Challenges Of The Architecture

• About cDB Capacity Planning
• cDB & pDB Creation
• Using Oracle Installer
• Using DBCA
• cDB & pDB Connections
• Using SQL*Plus
• EM Cloud Control

• Multitenant Security Model
• Multitenant Privileges & Roles
• Common Users
• Local Users
• Common & Local Roles & Privileges
• Commonly & Locally Defined
• Commonly & Locally Granted
• Common & Local Profiles
• Common & Local Dictionary Access
• Multitenant Unified Auditing
• Local Audit Policies
• Querying The Unified Audit Trail
• Common Audit Policies
• Auditing Management With EM CC

• Provision & Decommission pDBs
• EM CC Provisioning Prerequisites
• pDB File Location Prerequisites
• Provision A pDB From pdb$seed
• Provision Using SQL
• Provision Using EM CC
• Post Provisioning Checklist
• Drop A pDB
• Querying cDB & pDB Metadata

• Clone A pDB
• Unplug & Plug-In A pDB
• Migrate A Non-cDB To A pDB
• pDB Provisioning Using EM CC
• pDB Provisioning Using DBCA

• About Multitenant Administration
• cDB Administration
• cdb$root Administration
• pDB Administration

• Manage Permanent Tablespaces
• Manage Temporary Tablespaces

• Devising Multitenant Recovery Plan
• RMAN Multitenant Usage
• RMAN Multitenant Backup
• EM CC Multitenant Backup
• RMAN Multitenant Recovery
• Complete Recovery
• Incomplete cDB / pDB Point-in-time Recovery (PITR)
• Incomplete Table Point-in-time Recovery (PITR)
• Multitenant Flashback Database
• EM CC Multitenant Recovery
• Multitenant Database Duplication
• cDB Duplication
• pDB Duplication

• About Resource Management
• cDB Resource Plans & Directives
• pDB Resource Plans & Directives

• About Compression
• Table Compression
• Basic Table Compression
• Advanced Row Compression
• Additional Table Compression Considerations
• Index Compression
• Key Compression
• Advanced Index Compression
• Hybrid Columnar Compression
• Compression Analysis
• Using SQL Metadata Queries
• Using DBMS_COMPRESSION()
• Using EM CC

• About ILM
• The Oracle Database & ILM Support
• Heat Map Tracking
• Automatic Data Optimization (ADO)
• Adding ADO Policies Using SQL
• Managing ADO Policies Using SQL
• Managing ADO Policy Evaluation
• Managing ADO Policies Using EM CC

• About Traditional Table Caching
• Big Table Caching
• Full Database Caching
• In-Memory Column Store
• IMCS Internals
• Configuring The IMCS
• Assigning Objects To The IMCS
• Assigning Columns To The IMCS
• Monitoring IMCS Using EM CC

• About In-Database Archiving
• In-Database Archival Tables
• In-Database Archiving Of Rows
• Temporal Validity

• About Data Redaction
• The Redaction Functions
• Using Function Type dbms_redact.random
• Using Function Type dbms_redact.partial
• Function Type dbms_redact.partial Shortcuts
• Using Function Type dbms_redact.regexp
• Function Type dbms_redact.regexp Shortcuts
• Defining Redaction Policies
• Managing Redaction Policies
• Customizing Full Redaction
• Viewing Redaction Metadata
• Using EM Cloud Control
• Inference Attacks