Re: where is my trace

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tq786i9o6kr9c3_at_news.demon.nl...
>
> "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
>

Just to clarify (I hope):

There *is* a parameter 'user_dump_dest', which can be pointed to any directory you fancy. But if that parameter is left out of the init.ora, then there is a *default* directory, which from memory is the ORACLE_HOME/admin/<SID>/udump directory mentioned by the earlier poster.

I do believe, however, that I have seen an occasion on one of the training courses where a student's unix account had been set up incorrectly, such that he didn't have write permissions to the user_dump_dest specified in the init.ora -and trace files were requested but silently refused to be created. So maybe it's just a permissions problem.

Regards
HJR Received on Sat Sep 15 2001 - 15:19:49 CDT