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 -> Making sense of the SQL trace file

Making sense of the SQL trace file

From: rocr <rolland_cright_at_hotmail.com>
Date: Fri, 07 Dec 2001 20:21:06 GMT
Message-ID: <Sw9Q7.4132$8e.238096@news>


Hi gang,

  I create a trace file on one of the user processes that I am troubleshooting. I have opened the trace file and I am trying to make sense of the output. Could anyone decipher the meaning of the following:

  PARSING IN CURSOR #2 len=350 dep=1 uid=0 oct=3 lid=0 tim=61988085 hv=2216582187 ad='5e5a4cec'

I am especially curious as to the meaning of the tim values, are these seconds, 1/1000 sec, what the hey????

Cheers,
clueless Received on Fri Dec 07 2001 - 14:21:06 CST

Original text of this message

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