Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Replaceing Trace File instead of appending
"Mark Andrws" <mark.r.andrews_at_boeing.com> wrote in message
news:3CABA79C.6ABC8C7E_at_boeing.com...
> I am using sqlplus (Oracle 8) to dynamically turn tracing off and on
> using
> execute sys.dbms_system.set_sql_trace_in_session(sid,serial#,switch). I
> would like the trace file to be overwritten every time I turn the switch
> back on, but I cannot find the parameter to do so. I know in Oracle
> reports it is possible to set tracemode=trace_replace. Is there a
> parameter I can set in config.ora, init.ora or at the command line to
> cause this to happen?
> Thanks in Advance
> Mark Andrews
> mark.r.andrews_at_boeing.com
There isn't
Please do NOT crosspost or multipost.
You won't get a bigger audience and most people writing the bulk of
responses monitor all three groups. Hence, you are only wasting bandwith
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Wed Apr 03 2002 - 22:48:42 CST