mostly latch-free SCN?

From: John Clarke <jclarke_at_centroidsys.com>
Date: Thu, 9 Dec 2004 17:50:39 -0500
Message-ID: <20041209175039.3c01cf50@centroidsys.com>

Anyone have any idea what this is=3F

I was 10046 tracing a process and found it post a wait on mostly latch-f= ree SCN latch. Excerpt from trace file below.

WAIT #2: nam=3D'db file scattered read' ela=3D 1054 p1=3D17 p2=3D30500 p= 3=3D3
WAIT #2: nam=3D'db file sequential read' ela=3D 1377 p1=3D17 p2=3D30504 = p3=3D1
*** 2004-12-09 17:27:55.695

WAIT #2: nam=3D'latch free' ela=3D 49 p1=3D-4611686009467115424 p2=3D88 = p3=3D0
*** 2004-12-09 17:34:20.573

WAIT #2: nam=3D'db file sequential read' ela=3D 4850 p1=3D50 p2=3D119591=  p3=3D1
WAIT #2: nam=3D'db file sequential read' ela=3D 6175 p1=3D50 p2=3D119590=  p3=3D1

I'm not positive what the "^***" lines mean, but what I can tell is that=
 when hit the latch wait and displayed a wall time of 17:27, it didn't d=
o anything until the next "^***" line.  Shouldn't the ela in either the =

current or next wait match the elasped time=3F

Thanks in advance.

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

Received on Thu Dec 09 2004 - 16:50:05 CST