Re: Name of the sessions tracefile

From: Ralph Ganszky <ganszky_at_my-deja.com>
Date: Tue, 22 Jun 1999 12:59:47 GMT
Message-ID: <7ko1bu$85d$1@nnrp1.deja.com>

Hi Sybrand,

that was my opinion too but unix, especially HP-UX told me an other story. Although there are no old tracefiles in the user dump destination the tracefile name contains neither the pid of the shadow process nor of the client process. Any other suggestions?

Best regards
Ralph

In article <929994472.29889.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 07:59:47 CDT