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

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google