Oracle Database check PFILE or SPFILE usage

 

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