SQL_Trace File Names Under AIX

From: Jerry Apfelbaum <japfelba_at_ican.ca>
Date: Sun, 06 Dec 1998 18:26:57 -0500
Message-ID: <366B12C0.9F27127@ican.ca>

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 Sun Dec 06 1998 - 17:26:57 CST