Introduction to Common Wait Events
We will describe what the event means, what information Oracle provides you in the additional wait parameters, P1, P2 and P3 in the V$SESSION_WAIT view, the extended SQL trace file and the V$SESSION view in Oracle Database 10g Release 1. We will also discuss the wait time, or the timeout value for these wait events. Subsequent chapters will discuss in detail the common causes of these events and actions to take to minimize them.
We will also discuss the importance of tracking CPU usage statistics in conjunction with the wait event information.
buffer busy waits
The buffer busy waits event occurs when a session wants to access a data block in the buffer cache that is currently in use by some other session. The ...
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.
