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

From: FC <flavio_at_tin.it>
Date: Fri, 28 Nov 2003 23:26:45 GMT
Message-ID: <VQQxb.22974$AX1.894445@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 Received on Fri Nov 28 2003 - 17:26:45 CST