Re: where is my trace

"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns911D6EC97EED3SunnySD_at_24.0.3.73...
> "xxx" <www._at_ww.pl> wrote in news:9o02l3$baq$1_at_sunsite.icm.edu.pl:
>
> > Hi
> >
> > I can't find trace file in my oracle directory.
> > I set of course dump destination like:
> > background_dump_dest
> > user_dump_dest
> > core_dump_dest
> > but these are empty even I run 'alter database backup controlfile to
> > trace'. I set oracle_trace_enable = TRUE too.
> > Where should I search for it.
> >
> > Thanks in advance. Bartos
> >
> >
> On my Solaris system using OFA, the trace file is placed in
> /u01/app/oracle/admin/SID/bdump directory;
> where you replace "SID" with your actual value.
>
> HTH & YMMV, HAND!
Incorrect
The result of sql_trace and alter database backup controlfile to trace is placed into the directory pointed to by the user_dump_dest parameter. usually the file name has either the Unix pid or the NT thread number in it. You can find that by running
select spid from v$process p, v$session s where s.sid = (select sid from v$mystat where rownum = 1) and p.addr = s.paddr

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sat Sep 15 2001 - 13:31:42 CDT