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 -> SQL trace facility

SQL trace facility

From: Steven Christopher Charles Grant <S.C.C.Grant_at_ncl.ac.uk>
Date: 1997/08/04
Message-ID: <33E5F94F.3488815E@ncl.ac.uk>#1/1

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

Original text of this message

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