Re: SQL trace facility

From: Vikas Gautam <gautam_at_sequent.com>
Date: 1997/08/11
Message-ID: <5snurh$q5a@scel.sequent.com>#1/1

There is another way and that is using a role plustrce in ORACLE. You need to set AUTOTRACE on and have the role granted to you. I got the sql that creates the role from ORACLE as our s/w distribution did not have it. This is a pretty cool feature in SQL*PLUS as you do not have any temp files created nor do you have to run tkprof. The only limitation is that you do not get as good a report as tkprof generates.

Hope this helps,
Vikas

In article <5sn110$p8d_at_Raven.und.ac.za>, - <Ardiels_at_umfolozi.ntech.ac.za> wrote:
>In article <33E5F94F.3488815E_at_ncl.ac.uk>
>Steven Christopher Charles Grant <S.C.C.Grant_at_ncl.ac.uk> wrote:
>> 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

-----deleted------
-- 
----------------------------------

Vikas Gautam ,
Sequent Computer Systems,
847-318-0050 Received on Mon Aug 11 1997 - 00:00:00 CDT