How to Identify Which Segment is Associated with Buffer Busy Waits
(Doc ID 413931.1)
Last updated on OCTOBER 30, 2019
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
This note shows how to determine which segment is associated with buffer busy waits found in an AWR / statspack report, or 10046 trace.
It is very important to know which segments are affected by buffer busy waits in order to address the cause for the waits. This can be accomplished using 10046 traces (with TKProfs) or AWR / statspack output. The 10046 trace is better than the AWR / Statspack data because it allows you to directly associate the waits with SQL statements causing them and allows you to easily see how the waits affect the execution of that statement. AWR / statspack reports are still useful in a general way, but you will still not really know precisely which statements caused the waits.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document