Good explanation on 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? > > -- //www.freelists.org/webpage/oracle-l
