How to find if the instance using PFILE or SPFILE?

 

Execute the following query to see if the instance was started with a PFILE or SPFILE:

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