Re: trace file reuse???

I've tried creating an empty trace file with the same name but that doesn't work either.

"Gary Knopp" <gknopp_at_ascend.com> wrote in message news:8gh9fg$nu8_at_nntpb.cb.lucent.com...
> 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