Replaceing Trace File instead of appending

From: Mark Andrws <mark.r.andrews_at_boeing.com>
Date: Thu, 4 Apr 2002 01:08:44 GMT
Message-ID: <3CABA79C.6ABC8C7E_at_boeing.com>



[Quoted] 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 Received on Thu Apr 04 2002 - 03:08:44 CEST

Original text of this message