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 -> trace file reuse???

trace file reuse???

From: Gary Knopp <gknopp_at_ascend.com>
Date: 2000/05/24
Message-ID: <8gh9fg$nu8@nntpb.cb.lucent.com>#1/1

Hello,

    Does anyone know whether its possible to reuse a trace file     in a client session? I've been unable to make this work.

    For example...

        execute dbms_system.set_sql_trace_in_session(10,200,True)

...
... run sql commands here
...
execute dbms_system.set_sql_trace_in_session(10,200,False) This generates a file named 'myDB_ora_12345.trc' . If I rename the file to 'Trial1_hold.trc' and rerun the commands again the trace file 'myDB_ora_12345.trc' is not created again. I don't understand why the trace package doesn't handle this condition. It's a real pain having to reconnect the client to test various query scenarios.
Received on Wed May 24 2000 - 00:00:00 CDT

Original text of this message

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