RE: Cache buffer chains (kslbegin)

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 24 Apr 2006 16:03:52 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F59D7@MSXVS04.trivadis.com>

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

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

Received on Mon Apr 24 2006 - 09:03:52 CDT