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

Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 Certification Training Course Overview

The Oracle Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 training course give you a detailed knowledge of Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, new partitioning methods, Recovery Manager,online operations, Oracle Data Pump, SQL*Loader, Full Database In-Memory Caching, Automatic Data Optimization, Transparent Data Encryption (TDE) and other areas of security, In-Memory Column Store and Automatic Big Table Caching.

Who Should Do Oracle Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 training?

  • Database Administrators
  • System Administrator
  • End Users

Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 (40 Hours) Download Course Contents

Live Online Training
Group Training 3000
06 - 10 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)
03 - 07 Jan 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 3450
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

Module 1: Introduction
  • Global objectives of the course
  • Lessons grouped by modules
  • Schedule of the week
Module 2: Auditing Using Unified Audit
  • Quick review of 11g R2 audit trail implementation
  • Overview of the Unified Audit Trail
  • Creating and enabling audit policies for all users to whom the role is granted directly
  • Capturing VPD (Virtual Private Database) generated predicates
Module 3: Controlling Data Access Using Privileges and Profiles
  • New 12.2 administrative privileges
  • Password file enhancements
  • Enhance the security of administrative users
  • Enforce the associated profile’s password limits
  • Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure
  • Using mandatory INHERIT PRIVILEGES privilege to select from BEQUEATH current_user views
  • Using new INHERIT (ANY) REMOTE PRIVILEGES privilege
Module 4: Controlling Data Access Using Privilege Analysis
  • Overview of database privilege analysis
  • Granting the CAPTURE_ADMIN role to enable management of privilege capture
  • Creating and starting/stopping privilege captures and runs
  • Viewing privilege analysis result
Module 5: Redacting Data
  • Overview of Oracle Data Redaction
  • Types of Data Redaction Policies
  • New redaction format library in EM GUI
  • Redaction policy expression
  • Redacting with Nullify redaction function
Module 6: Encrypting Data
  • Encrypt / decrypt / rekey tablespaces online
  • Configure automatic tablespace encryption
Module 7: Controlling Data Access Using Transparent Sensitive Data Protection
  • Configure and use TSDP with VPD
  • Configure and use TSDP with Data Redaction
  • Configure and use TSDP with Unified Auditing
  • Configure and use TSDP with Fine-Grained Auditing (FGA)
  • Configure and use TSDP with Transparent Data Encryption (TDE)
Module 8: Making Data Available by Using RMAN Features
  • RMAN enhancements
  • Transport Data Across Platforms
  • Table recovery
  • Automate the manual recovery process by using Recover Database Until Available Redo
  • REPAIR FAILURE command extented
Module 9: Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables
  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • Querying against external tables and overriding external table clauses
Module 10: Making Data Available by Performing Online Operations
  • Describe online redefinition supports
  • Move and compress table partitions ONLINE
Module 11: Partitioning Data
  • Enable reference partitioning with interval partitioned parent tables
  • Incorporate the CASCADE option for TRUNCATE PARTITION and EXCHANGE [SUB]PARTITION operations
  • Convert partitioning Range to Interval and vice-versa
  • Convert subpartitioning Range to Interval and vice-versa
  • Simplify the maintenance of (sub) partitioned tables
  • Composite partitioning
Module 12: Managing Information Lifecycle Using ADO
  • Data classification in 12c : tablespace, group, object, row levels
  • Configure heat map
  • Automatic movement and compression
  • Compression levels and types
  • Policy declaration
  • Customized automated action execution with user-defined function
  • Execution in scheduled maintenance windows and by MMON
  • Customized schedule with DBMS_ILM package
Module 13: Managing Information Lifecycle Using In-Database Archiving and Temporal
  • Challenges of old data in tables and 11g solutions
  • In-database archiving new solutions
  • Use ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Temporal Validity versus Temporal History (Transaction Time of FDA)
  • Set a Temporal Validity by using PERIOD FOR clause of CREATE / ALTER TABLE
  • New SQL temporal data type
Module 14: Monitoring DB Operations and Performance
  • Overview
  • Use cases
  • Current Tools
  • Define a DB operation
  • Monitoring: Bracketing an Operation
  • Monitoring the Progress of Operations
  • DB Operation Tuning
  • DB Operation Active Report
Module 15: Configuring In-Memory Column Store
  • In-Memory Database option goals and benefits
  • Row format and columnar format
  • New SGA component
  • Deployment
  • Compression and priority in-memory segments attributes
  • Dictionary tables, added columns, IM statistics and IM Advisor
  • IM FastStart
  • Interaction with other products
Module 16: Using In-Memory Column Store
  • Caching results of frequently evaluated expressions and virtual columns
  • Optimizing joined columns by creating join groups
Module 17: Improving Performance Using In-Memory Caching
  • Setting up Full Database In-Memory Caching
  • Explaining the two buffer replacement algorithms of Automatic Big Table Caching
  • Configuring Automatic Big Table Caching with DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameter
  • Using Automatic Big Table Caching
Module 18: Improving SQL Performance
  • Statistics gathering performance improvements: Optimizer Statistics Advisor
  • Adaptive Execution Plan
  • Benefit from automatic dynamic sampling
Module 19: Using Real Application Testing Enhancements
  • SQL Performance Analyzer enhancements
  • SQL Plan Management enhancements
  • Database Replay enhancements
Module 20: Improving Performance Using Other Features
  • Manage session PGA limit
  • Multiple indexes on the same set of columns
  • Describe Advanced Row Compression and Avanced Index Compression HIGH level
  • Reduce Cursor Invalidations for DDLs
  • Define real-time materialized views with on query computation and ON STATEMENT refresh materialized views
  • Using multi-process multi-threaded Oracle architecture
  • Describe Database Smart Flash Cache enhancements
  • Use temporary undo for your temporary tables
Download Course Contents

Request More Information

Course Prerequisites
  • Understanding of Oracle Database 11g R2
  • Understanding of Oracle Multitenant Container Database architecture

Upon completion of this training you will know:

  • Manage security with Unified Auditing, privileges and profiles, Privilege Analysis, Data Redaction, Data Encryption, Transparent Sensitive Data Encryption
  • Describe the new RMAN enhancements
  • Manage data availability with new features of Oracle Data Pump, SQL*Loader and external tables, performing online operations
  • Manage data partitioning
  • Manage Information Lifecycle ADO, using In-Database Archiving and Temporal features
  • Describe database operations
  • Configure and use In-Memory Column Store
  • Use In-Memory Caching
  • Use Real Application Testing enhancements