Oracle Database 12c R1: New Features for Administrators Ed 2

Oracle Database 12c R1: New Features for Administrators Ed 2 Certification Training Course Overview

Oracle Database 12c R1: New Features for Administrators Ed 2 training course helps you understand about the new and enhanced features and options of Oracle Database 12c. In Oracle Database 12c R1: New Features for Administrators Ed 2 you will learn how these features and options increase security, manageability and performance. In this course, you will be introduced to Oracle Database Cloud Service.

Who Should do this course?

  • Administrator
  • Database Administrators
  • System Administrator

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

Live Virtual Classroom
Group Training 1700
08 - 12 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 1950
4 Hours
8 Hours
Week Days
Week End

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
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Customers who bought this course also bought

• MySQL for Developers Ed 5
• Oracle Cloud Infrastructure Introduction
• Oracle Database 12c: Admin, Install and Upgrade Accelerated
• Oracle Database 12c: Advanced PL/SQL
• Oracle Database: Managing Multitenant Architecture Ed 1
• Oracle Database 12c R2: SQL Tuning for Developers Ed 2
• Oracle Database 19C:Administration Workshop
• Oracle Database: Introduction to SQL
• Oracle Linux System Administration II
• Oracle WebLogic Server 12c: Administration I Ed 3

Course Modules

Module 1: Enterprise Manager and Other Tools
  • Enterprise Manager (EM) Cloud Control home page
  • Enterprise Manager Express home page versus Enterprise Manager Database Control
  • SQL Developer with new functionalities
  • OUI, DBCA
Module 2: Basics of Multitenant Container Database (CDB)
  • Benefits of the multitenant architecture
  • Differences between the root container and pluggable database containers
  • Structure of the root
  • Structure of Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx views
  • Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler
Module 3: Configuring and Creating CDB and PDBs
  • Tools: DBCA and SQL*Plus
  • Configuration and creation of CDB
  • Exploring the Structure (CDB_xxx views and EM)
  • Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express
  • Create a new PDB from PDB$SEED
  • Create a PDB from a non-CDB
  • Clone a PDB into the same CDB or into another CDB using DB links
  • Plug in an unplugged PDB
Module 4: Managing CDB and PDBs
  • Connect to CDB as administrator
  • Connect to a PDB using a service name
  • Start up a CDB
  • Open / Close a PDB (SQL*Plus, srvctl, EM)
  • Open / Close all PDBs
  • Shut down a CDB
  • Preserve or discard the PDBs open mode when the CDB restarts
  • Change PDB state
Module 5: Managing Tablespaces, Common and Local Users, Privileges and Roles
  • Create permanent tablespaces in the root and PDBs
  • Manage common and local schemas and users in the root and PDBs
  • Manage system and object privileges to common and local grantees granted "commonly" or "locally
  • Manage common and local roles granted "commonly" or "locally"
Module 6: Managing Backup / Recovery / Flashback
  • Backup a whole CDB
  • Backup a PDB
  • Recover CDB from redo log files, control files, undo datafiles loss
  • Recover PDB from PDB datafiles loss
  • Flashback at CDB level
  • Explain the two methods of migration
Module 7: Online Datafile Move and Automatic Data Optimization
  • Data classification in 12c : tablespace, group, object, row levels
  • Configure heat map
  • Automatic movement and compression
  • Compression levels and types
  • Policy declaration: simple declarative SQL extension
  • Customized automated action execution with user-defined function
  • Execution in scheduled maintenance windows and by MMON
  • Customized schedule with DBMS_ILM package
Module 8: In-Database Archiving
  • 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)
  • New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
  • New SQL temporal data type
Module 9: Auditing Enhancements
  • Review of 11g R2 audit trail implementation
  • Overview of the Unified Audit Trail
  • Enabling the Unified Audit Trail
  • Creating a separate tablespace for the unified audit trail
  • Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
  • Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
  • Creating audit policies
Module 10: Privileges Enhancements
  • Implementing Separation of Duty for Database Administration Tasks
  • Using Database Privilege Analysis
  • Overview of Database Privilege Analysis
  • Granting the CAPTURE_ADMIN role to enable management of privilege captures
  • Creating and starting/stopping privilege captures
  • Viewing privilege profile data
  • Querying DBA_PRIV_CAPTURES
  • Explaining the purpose of the default ORA$DEPENDENCY profile
Module 11: Oracle Data Redaction
  • Overview of Oracle Data Redaction
  • Types of Masking Policies
  • Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Managing Masking Policies
  • Best practices for defining policy expressions
  • Understanding Masking of Statements Containing Subqueries
  • Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS
Module 12: General RMAN New Features and FDA Enhancements
  • Making Database Connections With RMAN
  • Using the SYSBACKUP Privilege
  • Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
  • Backing up and Restoring Very Large Files
  • Creating Multisection Backups
  • Transporting Data Across Platforms
  • Prerequisites and Limitations
  • Transporting Data: Processing steps
Module 13: Monitoring DB Operations
  • 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 14: Real-Time ADDM and Compare Period Advisor
  • Emergency Monitoring
  • Real time ADDM
  • Use cases
  • Goals
  • Define Workload dimensions
  • Reported items
  • Root Causes
  • Requirements for a report
Module 15: ADR and Network Enhancements
  • ADR file types
  • New File types
  • New File locations
  • New command for ADRCI
  • Improve performance by Compression
  • Setup Compression
Module 16: In-Memory Column Store
  • In-Memory Database option goals and benefits
  • Row format and columnar format
  • New SGA component:
  • IMCU synchronization
  • Deployment and behaviors
  • Compression ratio
  • New dictionary tables and added columns
  • New statistics: IM %
Module 17: In-Memory Caching
  • Setting up Full Database In-Memory Caching
  • Using Full Database In-Memory Caching
  • Explaining the two buffer replacement algorithms of Automatic Big Table Caching
  • Configuring Automatic Big Table Caching with PARALLEL_DEGREE_POLICY and DB_BIG_TABLE_CACHE_PERCENT_TAR
  • Using Automatic Big Table Caching
Module 18: SQL Tuning
  • Adaptive Execution Plans
  • SQL Plan Directives
  • Statistics Gathering Performance Improvements
  • Histogram Enhancements
  • Enhancements to Extended Statistics
  • Adaptive SQL Plan Management
Module 19: Resource Manager and Other Performance Enhancements
  • Manage resources between PDBs
  • Manage resources within a PDB
  • Manage resources with CDB and PDBs plans
  • Manage runaway queries
  • Control the in-memory database repopulation resource consumption
  • Automated maintenance tasks
  • Current Architecture: Unix multiprocess / one thread, NT/Windows one process / multithread
  • New Architecture: Multiprocess / MultiThread
Module 20: Index and Table Enhancements
  • Multiple indexes on the same set of columns as long as some characteristic is different
  • Create table with INVISIBLE columns
  • Support for invisible columns
  • Describe online redefinition supports
  • Explain LOCK timeout during FINISH_REDEF_TABLE
  • Describe the Advanced Row Compression
  • Using the following DDL statements in an online manner
Module 21: Oracle Database Cloud Service: Overview
  • Database as a Service Architecture & Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Automated Database Provisioning
  • Managing the Compute Node Associated With a Database Deployment
  • Backing Up and Recovering Databases on Database as a Service
  • Performing Recovery by Using the Service Console
  • Patching Database as a Service
  • Using the Oracle Database Cloud Service Console to Manage Patches
Download Course Contents

Request More Information

Course Prerequisites
  • Good knowledge of Oracle Database 11g

On Completion of this course you will be able to:-

  • Enterprise Manager and Other Tools
  • Basics of Multitenant Container Database (CDB)
  • Configuring and Creating CDB and PDBs
  • Managing CDB and PDBs
  • Managing Tablespaces, Common and Local Users, Privileges and Roles
  • Managing Backup / Recovery / Flashback
  • Online Datafile Move and Automatic Data Optimization
  • In-Database Archiving
  • Auditing Enhancements
  • Privileges Enhancements
  • Oracle Data Redaction
  • General RMAN New Features and FDA Enhancements
  • Monitoring DB Operations
  • Real-Time ADDM and Compare Period Advisor
  • ADR and Network Enhancements
  • In-Memory Column Store
  • In-Memory Caching
  • SQL Tuning
  • Resource Manager and Other Performance Enhancements
  • Index and Table Enhancements
  • Oracle Database Cloud Service: Overview

FAQ's