10046 Trace file oddity
- From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 31 Mar 2005 16:30:10 -0500
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
Other related posts:
- » 10046 Trace file oddity