Objectives
After completing this lesson, you should be able to
do the following:
Diagnose inappropriate use of SYSTEM, RBS,
TEMP, DATA, and INDEX tablespaces
Use locally managed tablespaces to avoid space
management issues
Detect I/O problems
Ensure that files are distributed to minimize I/O
contention and use appropriate type of devices
Use striping where appropriate
Tune checkpoints
Tune DBWn process I/O