Previous Topic: Optimize Network UsageNext Topic: Collecting Performance Statistics


Anticipate and Avoid Problems

Certain problems can be avoided, after you know when they occur. The following table lists the problems and their solutions.

Problem

Occurs when

Rollback extension

A transaction has to extend its size because the current rollback is not large enough to contain all the rollback data

Rollback contention

There are not enough rollback segments; therefore some transactions requesting rollbacks must wait for a rollback segment

Chaining and dynamic extension

The current extents assigned to tables, indexes, and rollback segments are insufficient to handle growth

Excessive I/O on hard drives

Data files are not spread among disks, resulting in degraded performance

Memory paging

Memory is insufficient to accommodate processing requirements; contributes to excessive I/O on hard drives