Buffer Busy Waits
Until Oracle9i Database, the buffer busy waits event parameters are file#, block#, and ID (reason code). In Oracle Database 10g Release 1, the first two parameters remain the same, but the third parameter gives the block class#. This wait event falls under the Concurrency wait class. Keep the following key thoughts in mind when dealing with the buffer busy waits event.
The Oracle session is waiting to pin a buffer. A buffer must be pinned before it can be read or modified. Only one process can pin a buffer at any one time.
buffer ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
