Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 10046 trace: 'latch free' then 'db file seq. read' waits

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

From: Spendius <spendius_at_muchomail.com>
Date: 13 Jun 2006 07:42:04 -0700
Message-ID: <1150209724.327027.156650@u72g2000cwu.googlegroups.com>


Hi,
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 ?

(to me the answer is yes but... one never knows)

Thanks.
Sp Received on Tue Jun 13 2006 - 09:42:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US