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

Re: Making sense of the SQL trace file

From: rocr <rolland_cright_at_hotmail.com>
Date: Sat, 08 Dec 2001 14:43:18 GMT
Message-ID: <aGpQ7.4265$8e.252135@news>


Thanks everyone, that was a big help.
"rocr" <rolland_cright_at_hotmail.com> wrote in message news:Sw9Q7.4132$8e.238096_at_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 Sat Dec 08 2001 - 08:43:18 CST

Original text of this message

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