Re: SQL trace facility

From: Nick Butcher <nickb_at_btinternet.com>
Date: 1997/08/04
Message-ID: <01bca105$683937e0$63f20082@otis>#1/1

Steven

1. Add 'TIMED_STATISTICS = TRUE' to your init.ora file. Be sure to 'hash' the line out when you no longer need this as there is a slight performance overhead.
2. The trace file should be the last file written to the directory specified with the USER_DUMP_DEST parameter in the init.ora file.

   ---

Nick Butcher
nickb_at_btinternet.com

Steven Christopher Charles Grant <S.C.C.Grant_at_ncl.ac.uk> wrote in article <33E5F94F.3488815E_at_ncl.ac.uk>...
> Hi
>
> When using SQL Trace Facility, there are two initialization parameters
> which I am having trouble with.
>
> 1. How do I enable the TIMED_STATISTICS parameter to TRUE?
>
> 2. After enabling the trace facility to true, the manual says Oracle
> generates a trace file containing statistics. Oracle writes these trace
> files to the user dump destination. How do I find out the name of a
> trace file so that I can run TKPROF?
>
> THANKS
>
> Steven Grant
>
  Received on Mon Aug 04 1997 - 00:00:00 CDT