Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators

5 Day Course
Hands On
Code O12CNFR2

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite


This Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators course is designed to give Oracle 11gR2 Database Administrators practical experience in using the new features that have been introduced in Oracle Database 12cR1 and 12cR2.

The delegate will gain an appreciation of how the enhanced features of Oracle Database 12cR1 and 12cR2 may be implemented at their own sites.

Note: This course covers an overview only of container and pluggable databases.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.


The delegate will learn and acquire skills as follows:

  • Install the Oracle Database 12cR2 software with the OUI
  • Create a non-container Oracle Database 12cR2 Database
  • Upgrade an Oracle 11gR2 database to Oracle 12cR2
  • New database management features
  • Implement Unified Auditing
  • Implement and use Administrative privileges
  • Schema and data management new features
  • Enable Privilege Analysis
  • The SQL*Plus history commands and the SQLcl utility
  • New SQL and PL/SQL features
  • New RMAN and availability features
  • Data Redaction and Data Encryption new features
  • Performance tuning new features
  • Adaptive Execution Plans
  • SQL Plan Directives
  • Real-Time ADDM
  • New Data Pump, SQL*Loader and External Table features
  • Partitioning enhancements
  • Transparent Sensitive Data protection
  • Use In-Memory Column Store new features to increase SQL performance
  • SQL Tuning enhancements using the Optimizer Statistics Advisor and SQL join processing
  • Manage resources with Resource Manager performance profiles and memory directives
  • The Trace File Analyzer to collect and diagnose issues
  • Configure a heat map
  • Temporal history and validity

Target Audience

This Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality introduced in Oracle Database 12cR1 and 12cR2.

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Changes to Database Management Tools (3 topics)

  • Enterprise Manager Express Home Page
  • SQL Developer new functionality
  • Changes to the OUI and the DBCA

Oracle Database 12cR2 Architecture (13 topics)

  • Overview of the Oracle Database 12cR2 architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The root container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views
  • Plan an installation
  • System requirements and operating system prerequisites
  • Install the Oracle Database 12cR2 software with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Database software de-install

Create a Database with the Database Configuration Assistant (DBCA) (6 topics)

  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA

Preparation for Upgrade to Oracle Database 12cR2 (12 topics)

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • The Database Upgrade Assistant(dbua)
  • Upgrade process overview
  • Rolling upgrade
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database 12cR2 software
  • Create the new Oracle home

Perform an Upgrade to Oracle Database 12cR2 (4 topics)

  • Execute preupgrade.jar
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Deprecated database features and parameters

Post Upgrade Tasks (6 topics)

  • Common installation errors
  • Check the /etc/oratab file
  • Check the database version
  • Enterprise Manager Express configuration
  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing

Migrate Data with Data Pump (3 topics)

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link

New Tablespaces and Management Features (10 topics)

  • Data storage overview
  • Online rename and relocation of an active datafile
  • Restrict PGA size
  • Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
  • Temporary UNDO
  • DDL Logging
  • Full Database Caching mode
  • Smart Flash Cache
  • Automatic Big Table Caching
  • An overview of In-Memory Column Store

Online Datafile Move and Automatic Data Optimization (5 topics)

  • Move datafiles online
  • Data classification in 12c
  • Configure a heat map
  • Automatic movement and compression
  • Compression levels and types

In Database Archiving (7 topics)

  • Enhancements to Flashback Database Archive
  • New In-database archiving solutions
  • Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set the ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
  • SQL temporal data type

Enhancements to Database Auditing (14 topics)

  • Overview of database security
  • Overview of database auditing in Oracle Database 12c
  • Security compliance
  • Standard auditing
  • new unified audit trail overview
  • Create a tablespace for the Unified Audit Trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Unified Audit Trail
  • Specify audit options
  • Configure the Unified Audit Trail to set a tolerance level for lost of audit records
  • Create audit policies for privilege, action and component auditing
  • Audit policy enhancements
  • Audit by role
  • Purge old audit data

Enhancements to Privileges and Profiles (15 topics)

  • Implement the separation of duties for Database Administration tasks
  • Changes to tablespace quotas
  • Read object privileges
  • New password verification functions
  • Administrative user authentication enhancements
  • Administrative password security enhancements
  • Automatically lock inactive accounts
  • Control definer's rights privileges for database links
  • Database privilege analysis with Database Capture
  • Grant the CAPTURE_ADMIN role to enable management of privilege captures
  • Create, start and stop privilege captures
  • Viewing privilege profile data
  • Query the DBA_PRIV_CAPTURES view
  • The default ORA$DEPENDENCY profile
  • Execute the Invokers Rights privilege with the Inherit Privilege

Data Redaction (10 topics)

  • Overview of Oracle Data Redaction
  • Types of data masking policies
  • Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Manage masking policies
  • Understanding the masking of statements containing nested functions and subqueries
  • Grant Data Redaction privileges to a user
  • NULL as a redacted value
  • Named policy expressions
  • Miscellaneous Data Redaction enhancements
  • Query the data dictionary to obtain information on masking policies

Data Encryption Enhancements (8 topics)

  • Transparent Data Encryption
  • Create and open a Keystore
  • Start a CDB and PDBs with a Keystore
  • Table encryption
  • Tablespace encryption
  • Encrypt SYSTEM, SYSAUX and temporary tablespaces
  • Considerations when deciding to use online tablespace encryption

Transparent Sensitive Data Protection (6 topics)

  • New security features support for TSDP
  • TSPD with Unified Auditing
  • TSPD with Fine-Grained Auditing
  • TSPD with TDE Column Encryption
  • Auditing parameters used with TSDP policies
  • TSDP data dictionary views

New RMAN Features (15 topics)

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • RMAN syntax enhancements
  • Enhanced table point in time recovery
  • The enhanced REPAIR FAILURE command
  • Create multi-section backups
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate database operation with the NOOPEN option
  • Backup and restore very large files
  • Cross platform backup and restore
  • Recover a database after missing redo logs found
  • Duplicate a database using TDE
  • RMAN duplication of TDE tablespaces

Schema and Data Changes (12 topics)

  • Create identity columns
  • Create a table with invisible columns
  • Set default values for table columns
  • Truncate table cascade
  • Session level sequences
  • Create multiple indexes on the same set of columns
  • Advanced Row Compression
  • The Schema Change Plan flow
  • Change requests
  • Schema synchronization
  • The Data Comparison package
  • Comparison job results

SQL and PL/SQL Enhancements (20 topics)

  • SQL*Plus Enhancements
  • Last login time
  • The login.sql file
  • SQL*Plus command line history
  • SQL*Plus performance settings options
  • The SQLcl command line interface
  • Longer object names
  • Markup CSV
  • Row limiting for Top-N result Queries
  • Approximate query processing
  • Conversion function enhancements
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements
  • Real Time Materialized View enhancements
  • PL/SQL Scope enhancements
  • The deprecate pragma for PL/SQL
  • Code coverage using DBMS_PLSQL_CODE_COVERAGE
  • Package White Lists

Performance Tuning New Features (21 topics)

  • Overview of performance tuning new features
  • The Adaptive Optimizer
  • Default values for OPTIMIZER_ADAPTIVE parameters
  • Adaptive Query optimization enhancements in 12.2
  • Continuous Adaptive Query plans
  • The Optimizer Statistics Advisor rules, findings, recommendations and actions
  • The Expression Statistics Store
  • Enhancements to SQL Plan Management
  • SQL Plan Directives
  • Dynamic statistics
  • Online statistics gathering for bulk loads
  • Gather statistics concurrently for multiple tables
  • Histogram enhancements
  • Enhancements to extended statistics
  • Overview of new ADDM Analysis features
  • Emergency Monitoring
  • Real time ADDM analysis
  • Define Workload dimensions
  • Enhancements to the SQL Performance Analyzer
  • Execution plan capture from AWR
  • Automatic Capture files

Resource Manager and Other Performance Enhancements (6 topics)

  • Automated maintenance tasks
  • The Multithreaded Model using Threaded Execution
  • Manage session PGA limit
  • Reduce cursor invalidations for DDLs
  • Advanced Index compression
  • HCC data compression with an ADO Row-level policy

ADR New File Types and Network Compression (6 topics)

  • ADR file types
  • New File types
  • New File locations
  • New commands for ADRCI
  • Improve performance by using Network Compression
  • Setup Compression

Data Pump and SQL*Loader Enhancements (10 topics)

  • Data Pump enhancements
  • Turn off redo log generation
  • Transport view as table
  • Dumpfile compression
  • Password encryption enhancements
  • Use FULL Transportable export and import
  • SQL*Loader enhancements
  • SQL*Loader and External table common enhancements
  • SQL*Loader Express
  • External Table Enhancements

Partitioning Enhancements (14 topics)

  • Move a partition online
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations
  • New Oracle 12.2 partitioning strategies
  • Automatic List Partitioning
  • Multiple Column List Partitioning
  • Multiple Column with Automatic List Partitioning
  • Interval sub-partitioning
  • Filter data during partition maintenance operations
  • Convert a non-partitioned table to a partitioned table
  • Read only partitions
  • Defer segment creation for sub-partitioning

Diagnosability (7 topics)

  • Set an ADR retention target
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA daemon
  • Start and stop the TFA Collector
  • Dynamic Data Pump tracing

Monitoring Database Operations (6 topics)

  • Overview of DB monitoring operations
  • Define a DB operation
  • Bracketing an operation
  • Monitoring the progress of operations
  • DB Operation tuning
  • DB Operation Active report


Delegates attending the Oracle Database 12cR1 and 12cR2 New Features for 11gR2 Administrators course should have administration experience of Oracle Database 11.2. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Nov Dec Jan Feb Mar Apr
O12CNF 5 Days $2,250

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course