Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Replaceing Trace File instead of appending

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@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 Received on Wed Apr 03 2002 - 19:08:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US