Re: SQL_Trace File Names Under AIX

Yes, timestamps are not reliable if multiple developers are doing traces on the system at the same time.

Another way is to embed a unique identifier in the trace. It is as simple as adding an extra query like this:

     select 'trace file for Prochak' from dual;

then scan the trace files for your identifier. Not exactly what you are looking for, but it's reliable.

Jerry Apfelbaum wrote:

> Does anyone know how to determine what the trace file will be named when
> SQL_Trace is enabled? For example, if I turn on SQL_Trace with:
>
> ALTER SESSIONS SET SQL_TRACE = TRUE;
>
> how can I determine programmatically what the name of the trace file will be?
> Trace file names generally take the form ORAnnnnn.trc, where nnnnn is some
> decimal integer.
>
> Under HPUX, I had found that it could be determined from the SPID column of the
> V$Process view. Under AIX (and MS-Windows) this does not seem to be the
> algorithm.
>
> Is there some way to determine this without guessing from file timestamps?
>
> Thanks
> Jerry
Received on Tue Dec 08 1998 - 16:49:42 CST