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

Home -> Community -> Mailing Lists -> Oracle-L -> 10046 Trace file oddity

10046 Trace file oddity

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Thu, 31 Mar 2005 16:30:10 -0500
Message-ID: <D31DDAA8055E92419B6CBB576F4800CB019FCEFE@mail1-corp.corp.paetec.com>


What would make a tim value jump, (as seen from a trace file from a = customer):

FETCH =
#43:c=3D0,e=3D27,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D6=
589577675
EXEC =
#44:c=3D0,e=3D25,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D6=
589577815
FETCH =
#44:c=3D0,e=3D48,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D6=
589577911
EXEC =
#45:c=3D0,e=3D54,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D6=
589578081
FETCH =
#45:c=3D0,e=3D126,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D=
6589578260
EXEC =
#46:c=3D0,e=3D42,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D6=
589578398
FETCH =
#46:c=3D0,e=3D136,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D=
6589578585

WAIT #38: nam=3D'db file sequential read' ela=3D 222968 p1=3D10 =
p2=3D38958 p3=3D1
WAIT #38: nam=3D'db file sequential read' ela=3D 133299 p1=3D14 =
p2=3D53168 p3=3D1

EXEC =
#38:c=3D0,e=3D357064,p=3D2,cr=3D5,cu=3D42,mis=3D0,r=3D1,dep=3D3,og=3D4,ti=
m=3D357064
EXEC =
#47:c=3D0,e=3D103,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D=
358627
FETCH =
#47:c=3D0,e=3D117,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D=
358824
EXEC =
#31:c=3D0,e=3D43,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D3=
58991
FETCH =
#31:c=3D0,e=3D62,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D3=
59099
EXEC =
#32:c=3D0,e=3D32,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D3=
59397
FETCH =
#32:c=3D0,e=3D55,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D3=
59511
EXEC =
#33:c=3D0,e=3D32,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D3=
59607
FETCH =
#33:c=3D0,e=3D43,p=3D0,cr=3D3,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D3=
59712
EXEC =
#34:c=3D0,e=3D58,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D3=
59840
FETCH =
#34:c=3D0,e=3D81,p=3D0,cr=3D5,cu=3D0,mis=3D0,r=3D1,dep=3D3,og=3D4,tim=3D3=
59949
EXEC =
#39:c=3D0,e=3D56,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D3,og=3D4,tim=3D3=
60238

The whole trace file is 300M but it happens a many times throughout the = file.

The database is running on Windoze and the Version is 9.2.0.6

Richard=20

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 31 2005 - 16:33:55 CST

Original text of this message

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