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: Destination for the SQL trace file?

Re: Destination for the SQL trace file?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 30 Sep 1999 17:06:17 GMT
Message-ID: <37f39881.173626410@news.earthlink.net>


if you're talking about SQL_TRACE=TRUE or alter system set sql_trace=true
then the files should be in
$ORACLE_BASE/admin/$ORACLE_SID/udump

On Thu, 30 Sep 1999 11:54:02 +0200, Erika Grondzakova <Erika.Grondzakova_at_cern.ch> wrote:

>Hello,
>
>How could I find out (not having the DBA privilege) where is the
>destination for the trace file generated be the SQL trace facility?
>
>Thanks in advance,
>
>Erika Grondzakova


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Thu Sep 30 1999 - 12:06:17 CDT

Original text of this message

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