Professional Training

Prerequisites

The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g. Those who lack such experience would be better served by completing the curriculum for new database administrators comprising the following course modules:
• ORACLE DATABASE 11G: ADMINISTRATION I
• ORACLE DATABASE 11G: ADMINISTRATION II
• ORACLE DATABASE 11G: BACKUP & RECOVERY

Those who only have experience administering Oracle databases prior to Oracle 10g should at least obtain and read the course ORACLE DATABASE: 10G NEW & ADVANCED FEATURES FOR ADMINISTRATORS before proceeding onto this course.

Volume 1

CONFIGURING THE SERVER FOR INSTALLATION
IDENTIFY SYSTEM REQUIREMENTS
OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
ORACLE_BASE
ORACLE_HOME
CONFIGURE LINUX INSTALLATION
ORACLE_HOSTNAME Environment Variable
CONFIGURE MS WINDOWS INSTALLATION
ORACLE_HOME Variable
ORACLE_HOSTNAME Variable
PREREQUISITE CHECKS & FIXUP UTILITY

ENTERPRISE EDITION INSTALLATION

START THE INSTALLATION
DESKTOP CLASS INSTALLATION 11G R2
POST-INSTALLATION CONFIGURATION

UPGRADE, DEINSTALLATION & PATCHING

DATABASE UPGRADE
NETCA
DBUA
ONLINE PATCHING
ORACLE DEINSTALLER

STORAGE ENHANCEMENTS

ORACLE ADVANCED COMPRESSION
HIGH-CAPACITY DISKS & THE REDO FILES
COMPRESSED TABLES
HYBRID COLUMNAR COMPRESSION
DEFERRED SEGMENT CREATION

DATABASE ARCHITECTURE CHANGES

NEW INSTANCE BACKGROUND PROCESSES
ORACLE EXADATA STORAGE SERVER
EDITIONS & ONLINE REDEFINITION
MISCELLANEOUS PARAMETER CHANGES
UNDO_MANAGEMENT

AUTOMATIC MEMORY MANAGEMENT

ABOUT MEMORY MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT
MEMORY_TARGET
MEMORY_MAX_TARGET
USING EM & THE MEMORY ADVISORS
THE DATABASE SMART FLASH CACHE

USING THE DATABASE RESULT CACHE

ABOUT THE RESULT CACHE
CONFIGURING THE RESULT CACHE
RESULT_CACHE_MAX_SIZE
RESULT_CACHE_MODE
RESULT_CACHE_MAX_RESULT
RESULT_CACHE_REMOTE_EXPIRATION
USING THE RESULT CACHE
RELIES_ON Clause
MANAGING & MONITORING RESULT CACHE
Using V$RESULT_CACHE_STATISTICS
V$RESULT_CACHE_MEMORY
V$RESULT_CACHE_OBJECTS
V$RESULT_CACHE_DEPENDENCY

ENABLING TRANSPARENT DATA ENCRYPTION

TRANSPARENT DATA ENCRYPTION
MANAGING TDE
IMPLEMENTING COLUMN ENCRYPTION

ORACLE SECUREFILES

LOB CONCEPTS & TERMINOLOGY
BASICFILES LOB
ALTER TABLE
SECUREFILES LOBS
Using EM
MONITORING SECUREFILES PERFORMANCE
MIGRATING BASICFILES TO SECUREFILES

ADDITIONAL SECURITY ENHANCEMENTS

DATA PUMP ENCRYPTION
BACKUP SET ENCRYPTION
EM Backup Encryption
RMAN Backup Encryption
Decrypt During Recovery
TABLESPACE ENCRYPTION
SQL Create Tablespace With Encryption
ENHANCED DEFAULT SECURITY SETTINGS
ENHANCED SECURITY OPTIONS

DIAGNOSING DATABASE PROBLEMS

FAULT DIAGNOSABILITY INFRASTRUCTURE
ADR Highlights From EM
USING THE ALERT LOG
ABOUT THE TRACE FILES
DATABASE INSTANCE HEALTH SNAPSHOT
USING THE SUPPORT WORKBENCH
ENABLE ORACLE CONFIGURATION MANAGER

MISCELLANEOUS NEW FEATURES

LOCKING ENHANCEMENTS
DDL_LOCK_TIMEOUT Parameter
INVISIBLE INDEXES
AUTOMATIC MAINTENANCE TASKS

Volume 2

GRID INFRASTRUCTURE INSTALLATION
WHAT IS THE GRID INFRASTRUCTURE?
IDENTIFY SYSTEM REQUIREMENTS
MANAGING LINUX DEVICES
MANAGING MS WINDOWS DEVICES
CONFIGURE LINUX INSTALLATION
GRID INFRASTRUCTURE INSTALLATION
VERIFY THE INSTALLATION
SUBSEQUENT DATABASE INSTALLATION

AUTOMATIC STORAGE MANAGEMENT

ADMINISTERING THE ASM INSTANCE
ASM MIGRATION USING EM
ORACLE 11G ASM ENHANCEMENTS
COMPATIBLE.ASM and COMPATIBLE.RDBMS
DISK_REPAIR_TIME
ASM_PREFERRED_READ_FAILURE_GROUPS
ADMINISTRATION USING EM

ORACLE FLASHBACK TECHNOLOGY

FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK VERSIONS QUERY
FLASHBACK TRANSACTION QUERY
FLASHBACK TRANSACTION BACKOUT
Using DBMS_FLASHBACK()

FLASHBACK DATABASE

CONFIGURING THE FLASH RECOVERY AREA
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE

RMAN ENHANCEMENTS

VIRTUAL PRIVATE CATALOGS
Manage VPC Rights
Manage A VPC
BUILDING DYNAMIC SCRIPTS
BACKUP OPTIMIZATION
ENHANCED PARALLELISM & SECTION SIZES
ARCHIVAL BACKUPS

DATABASE DUPLICATION & CLONING

WHY PERFORM DATABASE DUPLICATION?
RMAN DUPLICATE DATABASE
RMAN DUPLICATE
DATABASE CLONING

RECOVERY WITH DATA RECOVERY ADVISOR

DETECTING CORRUPTION
V$DATABASE_BLOCK_CORRUPTION View
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
RECOVERY USING DATA RECOVERY ADVISOR
RMAN Interface

Volume 3

CHANGE MANAGEMENT
UNDERSTANDING THE APPLICATION ARCHITECTURE
SYSTEMS INFRASTRUCTURE CHANGES
CHANGE MANAGEMENT LIFECYCLE

WORKLOAD CAPTURE

PREPARING THE CAPTURE DATABASE
WORKLOAD CAPTURE USING THE EM WIZARD
WORKLOAD CAPTURE USING THE API

CONFIGURE THE REPLAY DATABASE

REQUIREMENTS OF A REPLAY DATABASE
RMAN DUPLICATE

DATABASE REPLAY

PREPROCESS CAPTURED WORKLOAD
REPLAY PREREQUISITES
REPLAY WORKLOAD
MONITOR THE REPLAY OPERATION

SQL PERFORMANCE ANALYZER

ABOUT SQL PERFORMANCE ANALYSIS
MANAGING SQL TUNING SETS
SQL PERFORMANCE ANALYZER TASKS
SQL PERFORMANCE ANALYSIS
SOLUTIONS
SQL PERFORMANCE ANALYSIS-1
SQL PERFORMANCE ANALYSIS-2
SQL PERFORMANCE ANALYSIS-3 •
QL PERFORMANCE ANALYSIS-4
SQL PERFORMANCE ANALYSIS-5
SQL PERFORMANCE ANALYSIS-6
SQL PERFORMANCE ANALYSIS-7

REPLAY ANALYSIS

LAUNCH REPLAY ANALYSIS
CONDUCT CONFIGURATION CHANGE ANALYSIS
USE THE PL/SQL API