Home | Previous Page | Next Page   Administrative Utilities > The onstat Utility >

Monitor the Database Server Status

One useful feature of onstat output is the heading that indicates the database server status. Whenever the database server is blocked, onstat displays the following line after the banner line:

Blocked: reason

The variable reason can take one of the following values.

Reason
Description
CKPT
Checkpoint
LONGTX
Long transaction
ARCHIVE
Ongoing archive
MEDIA_FAILURE
Media failure
HANG_SYSTEM
Database server failure
DBS_DROP
Dropping a dbspace
DDR
Discrete high-availability data replication
LBU
Logs full high-watermark
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]