Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is SQL Trace file written ?
Thanks a lot
Francesco
"Tanel Poder" <change_to_my_first_name_at_integrid.info> ha scritto nel
messaggio news:3f4c689c$1_1_at_news.estpak.ee...
> Check your parameter user_dump_dest value, the tracefiles should be there.
> If it is unset, then trace goes to default location
$ORACLE_HOME/rdbms/trace
> IIRC.
>
> Tanel.
>
> "F.Marchioni" <f.arrow_at_mailbox.com> wrote in message
> news:cJY2b.268039$lK4.8323606_at_twister1.libero.it...
> > Dear all,
> > I'd like to examine output produced by SQL Trace with TKPROF.
> > How do I know where SQL Trace file is written, once I issue
> > ALTER SESSION SET SQL_TRACE = TRUE ?
> > Thanks a lot
> > Francesco
> >
> >
>
>
Received on Wed Aug 27 2003 - 04:34:00 CDT