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 - 15:44:49 CST