Oracle Database 11g: New Features for Administrators Course

Upon completion of this course, the participant will be able to:

> Install and initially configure, or upgrade the Oracle 11g database software.
> Work within the structure of the changed Enterprise Manager (EM) interface and the database control.
> Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators.
> Implement comprehensive Oracle 11g automatic memory management.
> Enhance problem troubleshooting, diagnosis and resolution with the Fault Diagnosability Infrastructure.
> Backup and recovery enhancements provided through the RMAN framework.
> Duplicate and clone databases for the creation of test platforms, standby database installations and application workload replay.
> Guide the recovery of database failures and corruption using the Data Recovery Advisor.
> Enhance Automatic Storage Management (ASM).
> Improve storage including advanced compression techniques and algorithms.
> Consider both the challenge and the necessity of changes to the systems infrastructure and how these can disrupt production applications.
> Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database.
> Perform the capture of a production database workload while not interfering with the applications or users involved.
> Replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration.
> Configure clients which will simulate the network interaction of real-world users in a test configuration.
> Perform a detailed analysis of application execution within proposed database configurations to assess whether the application performance will progress or regress as a result of the proposed change.
> Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs.

DATABASE INSTALLATION & UPGRADE
IDENTIFY SYSTEM REQUIREMENTS
THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
ORACLE_BASE
ORACLE_HOME
CONFIGURE THE INSTALLATION ENVIRONMENT
ENTERPRISE EDITION INSTALLATION
DBCA
DATABASE UPGRADE PROCESS
DBUA
PATCHING OVERVIEW

DATABASE ARCHITECTURE CHANGES
REVIEW THE ORACLE ENTERPRISE ARCHITECTURE
MORE ABOUT THE ORACLE 11G DATABASE
UNDO_MANAGEMENT

AUTOMATIC MEMORY MANAGEMENT
ABOUT MEMORY MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT
MEMORY_TARGET
MEMORY_MAX_TARGET
USING EM & THE MEMORY ADVISORS

DIAGNOSING DATABASE PROBLEMS
ABOUT THE FAULT DIAGNOSABILITY INFRASTRUCTURE
USING THE ALERT LOG
ABOUT THE TRACE FILES
DATABASE INSTANCE HEALTH SNAPSHOT
USING THE SUPPORT WORKBENCH
ENABLE ORACLE CONFIGURATION MANAGER

SECURITY ENHANCEMENTS
TRANSPARENT DATA ENCRYPTION
COLUMN ENCRYPTION
TABLESPACE ENCRYPTION
DATA PUMP ENCRYPTION
BACKUP SET ENCRYPTION
ENHANCED DEFAULT SECURITY SETTINGS
ENHANCED SECURITY OPTIONS

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

MISCELLANEOUS NEW FEATURES
LOCKING ENHANCEMENTS
AUTOMATIC MAINTENANCE TASKS
COMPRESSION
ASM ENHANCEMENTS
ASM_PREFERRED_READ_FAILURE_GROUPS
COMPATIBLE.ASM and COMPATIBLE.RDBMS
DISK_REPAIR_TIME

ORACLE FLASHBACK TECHNOLOGY
ABOUT 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

FLASHBACK DATABASE
ABOUT 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
BUILDING DYNAMIC SCRIPTS
BACKUP OPTIMIZATION
ENHANCING PARALLELISM WITH 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
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
RECOVERY USING THE DATA RECOVERY ADVISOR

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

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

SQL PERFORMANCE ANALYZER
ABOUT SQL PERFORMANCE ANALYSIS
MANAGING SQL TUNING SETS
SQL PERFORMANCE ANALYZER TASKS
SQL PERFORMANCE ANALYSIS

The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g. 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.

Certification Examination
This course covers information necessary to upgrade ones Oracle Certified Professional (OCP) certification and complete the test EXAM #1Z0-050 ORACLE DATABASE 11G: NEW FEATURES.