How to find the trace file name?

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Tue, 05 Jan 1999 22:10:53 -0600
Message-ID: <3692E24B.9876A5CE@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 Tue Jan 05 1999 - 22:10:53 CST