Re: Name of the sessions tracefile

On Mon, 21 Jun 1999 17:45:28 GMT, Ralph Ganszky <ganszky_at_my-deja.com> wrote:

>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.
>

Hi,

the name of the trace file is
  select v.value||'/'||'ora_'||p.spid||'.trc'   from v$session s,v$process p,v$parameter v   where s.paddr=p.addr and s.audsid=userenv('SESSIONID')

     and v.name='user_dump_dest';
___
Fred Stojentin Received on Tue Jun 22 1999 - 08:06:23 CDT