Skip to content

Oracle Database check PFILE or SPFILE usage

cpx September 17, 2013 1 min read Oracle/ORA_PMON/1521

 

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"   FROM sys.v_$parameter WHERE name = 'spfile';

Init File Type
--------------------------------
SPFILE

 

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"   FROM sys.v_$parameter WHERE name = 'spfile';

Init F
------
PFILE

 

Be the first to comment

protected · no tracking

0 comments