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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Location of Trace file

Re: Location of Trace file

From: Tom Pall <tpall_at_realtime.net>
Date: Fri, 25 Oct 2002 08:58:57 -0800
Message-ID: <F001.004F3CD5.20021025085857@fatcity.com>


Show parameter ifile shows the ifile address, not the pfile address.

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> show parameter ifile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
ifile
file

SQL> show parameter background_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
background_dump_dest                 string      C:\oracle\admin\tom\bdump
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, October 25, 2002 4:12 AM



> Manoj,
>
> svrmgrl > show parameter ifile
>
> will give u the location of init.ora and
>
> svrmgrl > show parameter background_dump_dest
> svrmgrl > show parameter user_dump_dest
>
> will give u the location of alert and trace files respectively.
>
> HTH.
> Jp.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora oraora
> INET: oraoraora_at_rediffmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: tpall_at_realtime.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Fri Oct 25 2002 - 11:58:57 CDT

Original text of this message

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