Re: 10046 trace: 'latch free' then 'db file seq. read' waits

From: Spendius <spendius_at_muchomail.com>
Date: 14 Jun 2006 00:07:40 -0700
Message-ID: <1150268860.888497.35980@i40g2000cwc.googlegroups.com>

Argh... Forgot to say I'm dealing with an 8i DB, for which SQL> select name from v$latch where latch#=66; NAME

---

cache buffers chains

Sorry.

> When you find a series of 'latch free' waits with p2=66 in a 10046
> trace file that are immediately followed by a 'db file sequential read'
> wait (and then again 'latch free' p2=66 lines until another 'db file
> seq. read' line with different file#/block# values etc etc.) does it
> mean that Oracle now shows a wait for a seq. read on this very
> p1=file# and p2=block# on which it was trying to get a 'cache buffer
> chain' latch a second before ?
>
Received on Wed Jun 14 2006 - 02:07:40 CDT