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