Oracle Training : Oracle9i New & Advanced Features for DBAs

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

Oracle Training Audience

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 & OPERATIONv

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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved