Course Contents

Oracle 12c Course Contents

Save this Link in your favourites. We are coming with articles

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

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

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
•          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

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
•         Triggers ON PLUGGABLE DATABASE
•         Change PDB state

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"

Managing Backup / Recovery / Flashback and Migration

•         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

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

In-Database Archiving

•         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

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

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
•          Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure

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

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 optionB

Ba  Backing up and Restoring Very Large Files

•         Creating Multisection Backups
•         Transporting Data Across Platforms
•         Prerequisites and Limitations
•         Transporting Data: Processing steps

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

Schema and Data Changes

•          Explain the Schema Change Plan flow
•          Change requests
•          Schema synchronization
•          Explain the Data Comparison flow
•          DBMS_COMPARISON package
•          Guidelines and steps
•          Comparison job and results

SQL Tuning

•          Adaptive Execution Plans
•          SQL Plan Directives
•          Statistics Gathering Performance Improvements
•          Histogram Enhancements
•          Enhancements to Extended Statistics
•          Adaptive SQL Plan Management

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

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
•          Automated maintenance tasks
•          Describe the Multi-process Multi-threaded Oracle architecture
•          Learn how to use this architecture in Oracle 12c Database
•          Demonstrate the changes to shutdown procedures

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
•          Advanced Row Compression
•          Describe online redefinition supports
•          Explain LOCK timeout during FINISH_REDEF_TABLE
•         Using DDL statements in an online manner

ADR and Network Enhancements

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

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

•         Use FULL Transportable export and import
•         Oracle Data Pump enhancements
•         SQL*Loader enhancements
•         SQL*Loader and External table common enhancements
•         SQL*Loader Express Mode usage

 
Partitioning Enhancements

•          Move a partition online
•         ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER TABLE...ADD PARTITION Clauses: Overview
•        Split Partition Operation Enhancement
•        ALTER TABLE SPLIT SUBPARTITION
•        Merge Partition Operation
•        Add Partition Operation
•         Drop Partition Operation
•         ALTER TABLE DROP SUBPARTITION

 SQL Enhancements

•          Enumerate Increase in the length limits for VARCHAR2, NVARCHAR2, and RAW data types in Oracle SQL to 32767 (32k) byte
•          Enumerate miscellaneous enhancements
•          Using SQL Row limiting clause in a query