Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> trace file reuse???
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 CDT
...
... 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.
![]() |
![]() |