Re: how can see my database is in pfile or spfile mode ?

From: <raji_kb02_at_yahoo.co.in>
Date: 24 Mar 2006 03:33:41 -0800
Message-ID: <1143200021.361359.215950@v46g2000cwv.googlegroups.com>

If your database contain both the files "TOM(asktom)" solution will help you

sys_at_ORA920.US.ORACLE.COM> select decode(count(*), 1, 'spfile', 'pfile' )
  2 from v$spparameter
  3 where rownum=1
  4 and isspecified='TRUE'
  5 /

DECODE

---

spfile

isspecified is TRUE for some settings in the spfile file.

Carlos wrote:
> sql> show parameter spfile
>
> or
>
> sql> select * from V$parameter where name='spfile';
>
> If there is a value there, you are using a spfile.
>
> HTH.
>
> Cheers.
>
> Carlos.
Received on Fri Mar 24 2006 - 05:33:41 CST