Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Which Parameter file
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