TO CHECK WHETHER THE DB IS USING SPFILE OR PFILE

TO CHECK WHETHER THE DB IS USING SPFILE OR PFILE

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

Init F
------
SPFILE