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.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL

• The course Introduction to Oracle9i SQL
• The course Introduction to Oracle9i PL/SQL Language
• The course Introduction to Oracle9i Advanced SQL
• The course Oracle9i Database Administration – DBA I

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.

Oracle Training Course duration

5 Days

Oracle Training Course outline

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