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

This message: [ Message body ]
Next message: Rainer Herbst: "Re: drop user hangs"
Previous message: Marco: "Re: troubles with expired passwords on oracle application server"
In reply to: F.Marchioni: "Where is SQL Trace file written ?"
Next in thread: Tanel Poder: "Re: Where is SQL Trace file written ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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