Re: Making sense of the SQL trace file

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 7 Dec 2001 20:39:12 -0800
Message-ID: <a8aed4.0112072039.c4acaf3@posting.google.com>

"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

[Ganesh Raja Wrote :]

Hi,

Use the tkprof utility to decipher what is there in the trace file.

For the Entire Range of Syntax and Fiunctyionality of tkprof visit the prodcut documentaion library.

For a simplifies Version

go to Command Line say tkprof <trace_filename> <outputfilename>

HTH Regards,
Ganesh R Received on Fri Dec 07 2001 - 22:39:12 CST