Re: Help:Trace file name * I have similar Question *

"mark" <markw_at_crossworlds.com> wrote in message news:WEOu6.3497$FS3.189423_at_sjc-read.news.verio.net...
> Is there any tables that contain the name of the trace file created?
>
> I want to do an:
>
> alter database backup controlfile to trace;
>
> Then know the nae of the file so that i can use the utl_file package
>
> to access that file.
>
> But how do i find out the name of the file with out executing OS commands?
>
>
>
> Thanks
>
> Mark Wagner
>
> "DODO" <dodo_at_Ihatespam.com> wrote in message
> news:UmLu6.165830$Z2.2039566_at_nnrp1.uunet.ca...
> > Hello,
> > Does anyone know how Oracle names its trace files? I mean, after issuing
 the
> > ALTER SESSION SET SQL_TRACE = TRUE command, a .trc file is created on
 the
> > server. If you delete that file a new file with the same name is
 created,
 so
> > it is consistent.
> > TIA,
> > DODO
> >
> >
>
>

If you are running Unix you can download an utility script from www.ixora.com.au
On NT it would need to be slightly adapted. Note: if you are connected as sys the script is not going to work as sys doesn't have an audsid.
I'm pulling my hair out to think of a reason why you want to use the utl_file package on that file.
Please enligthen me.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Mar 24 2001 - 08:44:12 CST