Database Configuration and
I/O Issues

Objectives

I/O Statistic for Different 
Oracle File Types

Tablespace Usage

Distributing Files Across Devices

Oracle File Striping

Tuning Full Table Scan Operations

Diagnostic Tools for Checking I/O Statistics

I/O Statistics

Redo Log Groups and Members

Online Redo Log File Configuration

Archive Log File Configuration

Diagnostic Tools

Checkpoints

Guidelines

Multiple I/O Slaves

Initialization Parameters

Multiple DBWn Processes

Tuning DBWn I/O

Summary