Course Icon ORACLE Training

Oracle 12c New Features for Administrators

0800 1337 401

Overview

This Oracle 12c New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c. Delegates will gain an appreciation of how these features may implemented at their own sites.

Prerequisites

Delegates who wish to attend this Oracle 12c New Features for Administrators course should have good understanding of Oracle Database 11g administration. Knowledge of using PL/SQL packages is strongly recommended.

Objectives

This Oracle 12c New Features for Administrators course is designed to give existing Oracle 11g Database Administrators the knowledge and skills needed to implement the new features of 12c database. The Oracle Database 12c administrator will gain practical experience in administering and monitoring an Oracle 12c database.

Outline

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: CHANGES TO DATABASE MANAGEMENT TOOLS

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

Session 2: ORACLE DATABASE 12c ARCHITECTURE

  • Overview of the Oracle database 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

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA

  • 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

Session 4: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12c

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

Session 5: PERFORM AN UPGRADE TO ORACLE DATABASE 12c

  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB

Session 6: POST UPGRADE TASKS

  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing

Session 7: MIGRATE DATA WITH DATA PUMP

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

Course Contents - DAY 2

Session 8: CONFIGURE AND CREATE A CONTAINER DATABASE AND PLUGGABLE DATABASES

  • Create and configure a CDB using Enterprise Manager
  • Examine the structure of a CDB using Enterprise Manager and the CDB_xxx Views
  • Administer the database using Enterprise Manager and SQL*Plus
  • Create a new PDB from PDB$SEED
  • Create a PDB from a Non-CDB
  • Clone a PDB into the same CDB using DB links
  • Plug in an Unplugged PDB

Session 9: MANAGE A CONTAINER DATABASE AND PLUGGABLE DATABASES

  • Connect to a CDB as an Administrator
  • Connect to a PDB using a service name
  • Startup and shutdown a CDB
  • Open and close a PDB Using SQL*Plus and EM
  • Open and close all PDBs
  • Change the state of a PDB

Session 10: NEW TABLESPACES AND MANAGEMENT FEATURES

  • Data storage overview
  • Create permanent tablespaces in the root and PDBs
  • 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

Session 11: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES

  • Manage common and local schemas and users in the Root and PDBs
  • Manage system and object privileges to common and local grantees
  • Manage common and local roles

Session 12: MANAGE BACKUP, RECOVERY AND FLASHBACK OF A CDB AND PDB

  • Backup a CDB
  • Backup a PDB
  • Recover a CDB from the loss of redo log files, control files and undo datafile loss
  • Recover a CDB from the loss of datafiles
  • Use Flashback at CDB Level

Session 13: ONLINE DATAFILE MOVE AND AUTOMATIC DATA OPTIMIZATION

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

Course Contents - DAY 3

Session 14: IN DATABASE ARCHIVING

  • 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

Session 15: ENHANCEMENTS TO DATABASE AUDITING

  • Overview of database security
  • Overview of database auditing in Oracle Database 12c
  • Security compliance
  • Standard auditing
  • 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

Session 16: ENHANCEMENTS TO PRIVILEGES

  • Implement the separation of duties for Database Administration tasks
  • An overview of Database Privilege Analysis
  • 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
  • Use the mandatory INHERIT PRIVILEGES privilege to execute the invoker's rights procedure

Session 17: DATA REDACTION

  • 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 subqueries
  • Query the data dictionary to obtain information on masking policies

Session 18: NEW RMAN FEATURES

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate operation with the NOOPEN option
  • Backup and restore very large files
  • Cross platform backup and restore

SESSION 19: MONITORING DATABASE OPERATIONS

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

Course Contents - DAY 4

Session 20: SCHEMA AND DATA CHANGES

  • Create identity columns
  • Create a table with invisible columns
  • Set default values for table columns
  • Truncate table cascade
  • Session lavel 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 flow
  • The DBMS COMPARISON package
  • Comparison job and results

Session 21: SQL AND PL/SQL ENHANCEMENTS

  • SQL*Plus Enhancements
  • Last login time
  • Row limiting for Top-N result Queries
  • The Schema Change Plan flow
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements

Course Contents - DAY 5

Session 22: PERFORMANCE TUNING NEW FEATURES

  • Partitioning Enhancements
  • Data Pump Single-Partition Imports
  • Materialized Views and Query Rewrite Enhancements
  • The PIVOT and UNPIVOT Clauses
  • Data Compression
  • Enhancements to the Degree of Parallelism
  • In Memory Parallel Query
  • System Managed Indexes for List Partitioning
  • Overview of new ADDM Analysis features
  • Emergency Monitoring
  • Real time ADDM analysis
  • Define Workload dimensions
  • Reported items
  • Root causes
  • Report requirements

Session 23: 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

SESSION 24: ADR AND NETWORK SUPPORT

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

SESSION 25: DATA PUMP AND SQL*LOADER ENHANCEMENTS

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

SESSION 26: PARTITIONING ENHANCEMENTS

  • Move a partition online
  • An overview of the ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER TABLE...ADD PARTITION clauses
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations
See all of the available Technical Courses