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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Which Parameter file

Re: Which Parameter file

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 20 Oct 2000 13:18:35 GMT
Message-ID: <39F0462B.967961BD@edcmail.cr.usgs.gov>

Aidan,

Both Sybrand's & Van's answers were pretty good. I just thought that I would add how to determine exactly which parameter file is being used for a running instance. Sign on to SQL*Plus as SYSTEM and issue the following query:

     select name,value from v$parameter 
     where name ='ifile';

HTH,
Brian

aidan_at_qxlva.com wrote:
>
> Hi,
>
> I have what i think is a simple question and hope you can help, I have
> taken on a server running Oracle8 Enterprise Edition Release 8.0.5.0.0,
> there are two parameter files in $ORACLE_HOME/dbs and i am trying to
> find out which one is being used but dont know how.
>
> Thanks in advance
> Aidan Pearce.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Fri Oct 20 2000 - 08:18:35 CDT

Original text of this message

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