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: Harald Maier <maierh_at_myself.com>
Date: Wed, 27 Aug 2003 09:34:25 +0200
Message-ID: <m3ad9vo8ou.fsf@ate.maierh>


"F.Marchioni" <f.arrow_at_mailbox.com> writes:

> 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

Look for the initialization parameter user_dump_dest. E.g.

,----
| user_dump_dest /O2/oracle/admin/nine/udump `----

Harald Received on Wed Aug 27 2003 - 02:34:25 CDT

Original text of this message

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