Re: Understanding AWR 'buffer waits'

http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait

<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.

Best
Kyle
http://oraclemonitor.com

> Neil Kodner wrote:
>
> I'm having a hard time interpreting the Buffer Waits section of my AWR
> reports. Looking at the example at
>
> http://www.neilkodner.com/images/skitch/buffer_waits-20100323-105423.jpg
>
> Certain tablespaces (cubs_data) have far more buffer waits, compared to
> others, even others(uworks_misc_index) with a higher amount of reads and
> writes.
>
> 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

--
http://www.freelists.org/webpage/oracle-l