trace file reuse
From: Gary Knopp <gknopp_at_ascend.com>
Date: 2000/05/24
Message-ID: <8ghb6d$o3f_at_nntpb.cb.lucent.com>#1/1
Date: 2000/05/24
Message-ID: <8ghb6d$o3f_at_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)Received on Wed May 24 2000 - 00:00:00 CEST
...
... 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.