Home | Previous Page | Next Page   Utility Reference > onstat: Monitor Database Server Operations > The onstat -X Option >

Output Description

For each buffer in use, the -X option displays general buffer information that is also available with either the -b or -B option. For an explanation of these fields, refer to The onstat -b Option.

Unique to the -X option are the sharers and waiter fields. More than one thread can share data in a buffer. The sharers field lists the addresses of all user threads that share each buffer. During an update operation, a thread places an exclusive lock on a buffer, and no sharing occurs. In this situation, the waiter field lists the addresses of all user threads that are waiting for the buffer.

The onstat -b and -B options contain a waitlist field that displays the address of the first user thread that is waiting for the buffer. The -X option provides a complete list of addresses for all waiting threads.

The maximum number of shared buffers is specified as BUFFERS in the ONCONFIG file.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]