Re: Which Parameter file

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 23 Oct 2000 12:31:30 +0100
Message-ID: <8t17ih$2l9$1@soap.pipex.net>

Brian

This appears to give me my include files rather than the base pfile.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message
news:39F0462B.967961BD_at_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 Mon Oct 23 2000 - 06:31:30 CDT