Buffer Busy Waits (Oracle)

Use

You can use this procedure to display buffer busy waits.

Procedure

Choose Tool → Administration →Computing Center →Management System →Control →Performance Menu →Database →Activity.
Alternatively, use transaction code ST04.
Choose Detail analysis menu → Buffer busy waits.

The statistics presented on this screen tell you which types of Oracle block classes processes were waiting for. The number of waits for the four most common classes (data block, segment header, undo header and undo block) are usually shown with the cumulative time in milliseconds that processes were waiting.

These wait situations indicate that an Oracle process had to wait for the indicated block class which was in an inconsistent state.