Re: Name of trace file currently being written.

In article <BtwpHz.59J_at_nntp-sc.Intel.COM>, kortikar_at_mipos2.intel.com () writes:
> Hi
>
> I would like to find out name of trace file currently being written.
>
> set sql_trace true;
> explain plan .......
> set sql_trace false;
>
> I currenlty use "ls -lt /oracle/rdbms/log/*trc | head -1" to find this out.
> I need it for automating tkprof.
>
> Thanks a lot in advance.
>
> Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

I'm not sure how you would do that under UNIX. Do you have a facility to observe who is locking files? If so the check the trace directory for some file being locked by your session.

I'm working in Oracle under VMS and the way we do this is to define a logical (ie a directory definition) which overrides Oracle's default TRACE directory (for MY CURRENT session only). In this way I know that the TRACE file in MY particular directory is mine. Can you do that under Oracle for UNIX.

Hope this helps.

-- 

Bruce...        pihlab _at_ hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************