Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Replaceing Trace File instead of appending
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 Wed Apr 03 2002 - 19:08:44 CST
![]() |
![]() |