mostly latch-free SCN?
- From: John Clarke <jclarke@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 9 Dec 2004 17:50:39 -0500
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
