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

[Quoted] to reply remove '-verwijderdit' from my e-mail address