Oracle-L: 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