Re: Trace Facility

In <4rbug1$2mlu_at_mule2.mindspring.com>, jtdennis_at_atl.mindspring.com (John Dennis) writes:
>
>I'm trying to find out as much as possible about Oracle's trace
>facility. A year back I tried to find out as much as I could but was
>disappointed to find little to nothing on how to interpet the results,
>etc. I even called Oracle to no avail.
>
>Is there some new documentation, whitepaper, web page, etc that can
>help me find out detail info about the trace facility?
>
>Virtually,
>
>John Dennis
>
>John Dennis
>Tactics, Inc
>Atlanta, GA
>
John,

apart from using tkprof to get the data into a human readable form, there isn't much else you can do. The Oracle manuals do tell you what to look for in the tkprof output (low disk reads, low rows read to rows returned etc)

It takes a bit of practice to read the access paths (add explain=usr/pswd to the tkprof line)- a good knowledge of your database is needed for that.

Bye,
Steve

opinions expressed are mine and do not
necessarily represent those of my employer Received on Wed Jul 03 1996 - 00:00:00 CEST