How to find the trace file name?

This will only work if the user has a single session in the database. If there are more than one you will get two rows back which could confude things

-----Original Message-----
From: Kenny Gump [mailto:kgump_at_mylanlabs.com] Posted At: Wednesday, January 06, 1999 1:45 PM Posted To: server
Conversation: How to find the trace file name? Subject: Re: How to find the trace file name?

Frank,

Executing the following will give you the xxxxx in the oraxxxxx.trc file:

select s.username, p.username, p.spid
from v$session s, v$process p
where s.paddr = p.addr
and s.username = user
/

From that you can build the filename.

Kenny

Frank Hubeny wrote in message <3692E24B.9876A5CE_at_ntsource.com>...
>Is there a way to find the name of the trace file that is written after
>one runs
>
> alter session set sql_trace = true;
>
>I am aware that one answer is to look at the files in USER_DUMP_DEST
and
>find the one that has the appropriate date stamp, but I would like to
>automate the process of running tkprof after running a script
containing
>the alter session command.
>
>The only thing that stops this automation is knowing the name of the
>oraxxxxx.trc file that is being generated.
>
>Frank Hubeny
>Wheaton, IL
>
Received on Wed Jan 06 1999 - 19:29:00 CST