Re: can't get new trace file against the same SPID (8.1.7, Windows 2000)

"FC" <flavio_at_tin.it> wrote in message news:VQQxb.22974$AX1.894445_at_news1.tin.it...
> Hi all,
> I noticed that I can't get Oracle to create a new trace file against the
> same SPID more than once.
> For instance, if I enable sql_trace, then disable it and delete the
> resulting trace file, I can't get any new trace file against that SPID,
> unless I disconnect the session and reconnect.
> If the job I want to trace is run in batch mode, I can't trace it any more
> if I deleted the original trace file, unless I bounce the instance.
> The fact I am deleting the trace file while it is closed, that is after
> issuing alter session set sql_trace= false, seems to be irrelevant.
> I cannot understand why Oracle can't just create a new file with the same
> name.
>
> Any thoughts?
>
> Bye,
> Flavio
>
>

Probably because Oracle works on the filehandle. So if you delete the underlying file, it does not keep checking for the existence of the file and hence won't recreate it.

Instead of deleting, you can just cp /dev/null to the trace file to empty it.

Anurag Received on Sun Nov 30 2003 - 00:13:36 CST