Re: Name of the sessions tracefile

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 21 Jun 1999 21:48:57 +0200
Message-ID: <929994472.29889.0.pluto.d4ee154e@news.demon.nl>

Hi all,
I have a feeling this varies by platform. On unix the process id of the server side background process is included if I remember well. I just wrote a script to map v$session to v$process, I'm going to check tomorrow.

BTW: this forces you to cleanup the trace files frequently, or they are appended to and the results are completely bogus

Hth,

Sybrand Bakker, Oracle DBA

Ralph Ganszky wrote in message <7kltnk$gik$1_at_nnrp1.deja.com>...
>Hi all,
>
>I want to know if there is a documented way to determine the name
>of the tracefile that my own session will create when i switch
>sql_trace on? Or a way to determine the name of the file that was
>created by my session.
>
>Thanks in advance
>
>Ralph Ganszky
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jun 21 1999 - 14:48:57 CDT