Re: Cache buffer chains (kslbegin)

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Mon, 24 Apr 2006 12:55:57 -0700 (PDT)
Message-ID: <20060424195557.56479.qmail@web408.biz.mail.mud.yahoo.com>

You can also query v$segment_statistics for the object(s) with highest "buffer busy waits"

Joseph Amalraj

2006/4/24, Stephen Anderson :

> Hello,
> 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? I have the
> following information there:

--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l





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

Received on Mon Apr 24 2006 - 14:55:57 CDT