Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is SQL Trace file written ?
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 - 03:15:23 CDT