Understanding AWR 'buffer waits'
- From: Neil Kodner <nkodner@xxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, Neil Kodner <nkodner@xxxxxxxxx>
- Date: Tue, 23 Mar 2010 10:59:44 -0400
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?
Other related posts:
