This course is designed for database administrators who will be moving to the Oracle9i database platform. This course presents the new and advanced features of the database introduced in its 9i release.
Target audience for this course is senior Oracle database administrators who have experience with Oracle8i and wish to exploit the advanced features introduced in Oracle9i.
THE ORACLE 9I ARCHITECTURE • TERMINOLOGY CHANGES • INITIALIZATION PARAMETER FEATURES • V$PARAMETER Vs. V$PARAMETER2 • ABOUT SHARED SERVER MODE • ADDITIONAL ARCHITECTURE CHANGES
THE ORACLE 9I SYSTEM GLOBAL AREA (SGA) • UTILIZING THE LARGE POOL • ABOUT ORACLE 9I BUFFER CACHE & SUBCACHES • MAKING DYNAMIC SGA CHANGES • THE BUFFER CACHE ADVISORY UTILITY • THE SHARED POOL ADVISORY UTILITY • CREATING MULTIPLE BUFFER POOLS • MONITORING ADJUSTMENTS TO THE SGA • MONITORING & TUNING THE PGA/UGA • V$SESSTAT, V$STATNAME • V$PROCESS • V$SYSSTAT • V$SQL_WORKAREA_HISTOGRAM • V$SQL_WORKAREA_ACTIVE • V$PGASTAT • V$PGA_TARGET_ADVICE • V$PGA_TARGET_ADVICE_HISTOGRAM
AUTOMATIC UNDO SPACE MANAGEMENT • CONFIGURING AUTOMATIC UNDO SPACE MANAGEMENT • TUNING AUTOMATIC UNDO SPACE MANAGEMENT
RESUMABLE SPACE ALLOCATION • MANAGING RESUMABLE SPACE ALLOCATION • IMPLEMENTING SPECIAL FEATURES
FLASHBACK QUERY • IMPLEMENTING FLASHBACK QUERY • ABOUT THE DBMS_FLASHBACK() PACKAGE • ENABLE_AT_TIME() • GET_SYSTEM_CHANGE_NUMBER() • ENABLE_AT_SYSTEM_CHANGE_NUMBER() • DISABLE() • USING THE DBMS_FLASHBACK() PACKAGE
ADVANCED TABLESPACE OPERATIONS • DROPPING TABLESPACE DATA FILES • DEFAULT TEMPORARY TABLESPACES • LOCALLY MANAGED TABLESPACES • AUTOMATIC SEGMENT SPACE MANAGEMENT • USING NON-STANDARD BLOCK SIZES
IMPLEMENTING ORACLE MANAGED FILES
INSTANCE RECOVERY & FAST-START
HANDLING & ANTICIPATING STUCK RECOVERIES • HANDLING CORRUPTION OF DATA • PERFORMING TRIAL RECOVERY • USING DBVERIFY
ADDITIONAL BACKUP & RECOVERY FEATURES
USING THE RECOVERY MANAGER (RMAN) • USING THE RECOVERY CATALOG • CONFIRMING REGISTRATION & OTHER OPERATIONS • USING RUN BLOCKS & SCRIPTS • ALLOCATING CHANNELS • ACCESSING RMAN VIA OEM
SERVER-MANAGED BACKUPS WITH RMAN • PERFORMING FULL BACKUPS • PERFORMING INCREMENTAL BACKUPS
EXPLORING ENHANCED RMAN CAPABILITIES • RESUME FAILED BACKUP OPERATIONS • ESTABLISHING A BACKUP RETENTION POLICY • SHOW ALL CONFIGURATION SETTINGS • GENERATE CATALOG REPORTS • REPORT UNRECOVERABLE • REPORT NEED BACKUP • REPORT SCHEMA • LIST INCARNATION
SERVER-MANAGED RECOVERY WITH RMAN • RECOVERY MANAGER RECOVERY • PERFORMING RESTORATION & FILE MEDIA RECOVERY • PERFORMING BLOCK MEDIA RECOVERY
STANDBY DATABASES WITH ORACLE DATA GUARD • ABOUT THE DATA GUARD ARCHITECTURE • DATA GUARD INTERFACES
DATA GUARD CONFIGURATION & OPERATION • CONFIGURING LOG TRANSPORT • CONFIGURING LOG APPLY • DATABASE SWITCHOVER OPERATIONS • DATABASE FAILOVER OPERATION • MONITORING THE STANDBY DATABASE
UTILIZING LOGMINER • PREPARING THE LOGMINER UTILITY • PERFORMING LOG MINING • ADD_LOGFILE() • START_LOGMNR() • END_LOGMNR() • EXAMINING LOGMINER OUTPUT
DATABASE RESOURCE MANAGER • PLANS, GROUPS AND DIRECTIVES • PROCEDURES AND OPERATIONS • A SIMPLE RESOURCE PLAN • CREATE_SIMPLE_PLAN() Procedure • SYSTEM_PLAN • ADMINISTERING COMPLEX RESOURCE PLANS
