Re: Name of trace file currently being written.

Path: cmutual.com.au!aaj
Newsgroups: comp.databases.oracle
Distribution: world
Followup-To:
References: <BtwpHz.59J_at_nntp-sc.Intel.COM> <1992Sep4.082428.343_at_hhcs.gov.au> From: aaj_at_cmutual.com.au (Tony Jambu) Organization: Colonial Mutual Life Australia Subject: Re: Name of trace file currently being written. Keywords:

In article <1992Sep4.082428.343_at_hhcs.gov.au>, pihlab_at_hhcs.gov.au writes:
> 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.
>

I have wanted to do it in UNIX for some time and have been playing around. I eventually approach Oracle Support and the answer I got was.....NO

It is not possible to carry this out on UNIX. I hope someone out there can tell me otherwise.

-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au