The onstat utility provides a way to monitor database server shared memory from the command line. The onstat utility reads data from shared memory and reports statistics that are accurate for the instant during which the command executes. That is, onstat provides information that changes dynamically during processing, including changes in buffers, locks, and users.
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.
For an example of what onstat displays when the database server is blocked to preserve logical-log space for administrative tasks, see Monitoring the Logical Log for Fullness.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]