Re: Help:Trace file name

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Mar 2001 18:27:46 +0100
Message-ID: <tbn6jpi8ne1l58@beta-news.demon.nl>

"DODO" <dodo_at_Ihatespam.com> wrote in message news:UmLu6.165830$Z2.2039566_at_nnrp1.uunet.ca...
> Hello,
> Does anyone know how Oracle names its trace files? I mean, after issuing
the
> ALTER SESSION SET SQL_TRACE = TRUE command, a .trc file is created on the
> server. If you delete that file a new file with the same name is created,
so
> it is consistent.
> TIA,
> DODO
>
>

Platform?
On Unix it uses the spid of the background process serving the client. How to find that spid I posted several times, last time this week.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 23 2001 - 11:27:46 CST