Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is SQL Trace file written ?

Re: Where is SQL Trace file written ?

From: F.Marchioni <f.arrow_at_mailbox.com>
Date: Wed, 27 Aug 2003 09:34:00 GMT
Message-ID: <cW_2b.268294$lK4.8330110@twister1.libero.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US