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