CHECK WHETHER DATABASE RUNNING USING SPFILE OR PFILE

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
       FROM v$parameter WHERE name = 'spfile';