Displays information on the main or temp buffer allocator, which reserves space in the buffer cache for objects like sorts, hashes, and bitmaps.
monitor_options -bufalloc
Output field |
Description |
|---|---|
OU |
User_Resource_Reservation option setting (formerly Optimize_For_This_Many_Users) |
AU |
Current number of active users |
MaxBuf |
Number buffers under control of the buffer allocator |
Avail |
Number of currently available buffers for pin quota allocation |
AvPF |
Number of currently available buffers for prefetch quota allocation |
Slots |
Number of currently registered objects using buffer cache quota |
PinUser |
Number of objects (for example, hash, sort, and B-tree objects) using pin quota |
PFUsr |
Number of objects using prefetch quota |
Posted |
Number of objects that are pre-planned users of quota |
UnPost |
Number of objects that are ad hoc quota users |
Locks |
Number of mutex locks taken on the buffer allocator |
Waits |
Number of times a thread had to wait for the lock |