How to find the trace file name?

Hi

The xxxx part of the trace file is the OS process id of the process which generated the file. It can be found by joining the V$SESSION and V$PROCESS tables

select proc.spid os_process_id
from v_$session sess,

       v_$process proc
where proc.addr	=	sess.paddr
and	sess.audsid	= userenv('SESSIONID');

-----Original Message-----
From: Frank Hubeny [mailto:fhubeny_at_ntsource.com] Posted At: Tuesday, January 05, 1999 8:11 PM Posted To: server
Conversation: How to find the trace file name? Subject: How to find the trace file name?

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:26:42 CST