Re: Making sense of the SQL trace file

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Sat, 8 Dec 2001 09:28:11 -0800
Message-ID: <be30v9.gga.ln@zstux.ita.pwr.wroc.pl>

Hi Clueless,

The time is in CENTI Seconds. Most of the Oracle wait times are in Centi Seconds.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

"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 - 11:28:11 CST