Re: Understanding AWR 'buffer waits'
Date: Tue, 23 Mar 2010 09:58:03 -0700
Good explanation on
<http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait>which explains BBWs and how to user ASH to analyze them. ASH is much more appropriate for analyzing buffer busy waits than AWR . Should also make sure that there is actually any significant waits on BBWs before trying to tune them.
> Neil Kodner wrote:
> I'm having a hard time interpreting the Buffer Waits section of my AWR
> reports. Looking at the example at
> Certain tablespaces (cubs_data) have far more buffer waits, compared to
> others, even others(uworks_misc_index) with a higher amount of reads and
> Our datafiles for each of the tablespaces are equally distributed across
> 3 volumes on a SAN.
> How can i interpret the buffer waits and explain them in order to
> potentially identify a problem?
> -- http://www.freelists.org/webpage/oracle-l