RE: Cache buffer chains (kslbegin)

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <st.anderson@xxxxxxxxx>
  • Date: Mon, 24 Apr 2006 16:03:52 +0200

Stephen

>I have a 10 minute statspack report from a busy time period, and have seen 
>that buffer busy waits
>were the highest wait events. Would I be correct to then look at the Latch 
>Miss Source at the
>largest sleeps? 

IMHO before doing further analysis you should know:
- what kind of blocks are experiencing the buffer busy waits
- the reason code for the wait

According to this information different actions are available.

HTH
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: