sql_trace always writes into the same file

From: Lothar Armbrüster <larmbruester_at_vertriebsunion.de>
Date: 20 Jun 2002 00:54:56 -0700
Message-ID: <8cf2adac.0206192354.23fe5e7e@posting.google.com>

Hello out there,
today I stumbled over some inconvenience of Oracle 9.0.1.3 on W2k. When I set sql_trace to true, I always get the same trace file "<sid>S000.trc".
I was used to get a new trace file name for every session I trace. On Oracle 8.1.7 I got oraNNNNN.trc with a new number for every session.
Maybe some trace file number was reused but nornally I could trace different sessions into different trace files. This behaviour stopped to work for 9i.
Is there a way to revive it?

I did not find any initialization parameter to influence the naming of the trace file. Setting tracefile_identifier did not do any change.

Any Ideas?

Lothar Received on Thu Jun 20 2002 - 02:54:56 CDT