Oracle 12c New Features

Oracle Database 12c: New Features for Administrators NEW

Explore the Following New Features:

·         Online Data-file Move

·         Heat Map

·         Automatic Data Optimization

·         Temporal history

·         Temporal validity

·         Row-archival

·         Unified Auditing

·         Administrative privileges

·         Privilege Analysis

·         Data Redaction

·         Adaptive Execution Plans

·         SQL Plan Directives

·         Real-Time ADDM

·         Compare Period ADDM

·         Data Pump

·         Partitioning

·         SQL

Topics

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 option

·         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