How to Check Whether the Oracle Database is Using Pfile or SPfile?

advertisements

_____________________________________________________________________________________________________________________

Please find the query to check whether the database is running from pfile or spfile.

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Pfile or SPfile" FROM sys.v_$parameter

  2  WHERE name = 'spfile';

Pfile

------

SPFILE

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string     /data/oracle/product/11.1.0/dbs/spfileprod9.ora

Example 2

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter

WHERE name = 'spfile';

  2

Init F

------

PFILE

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string

_____________________________________________________________________________________________________________________

Website Stats