Re: Understanding AWR 'buffer waits'

From: kyle Hailey <>
Date: Tue, 23 Mar 2010 09:58:03 -0700
Message-ID: <>

Good explanation on

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

Received on Tue Mar 23 2010 - 11:58:03 CDT

Original text of this message