Checking if the database is using pfile or spfile

Use the following SQL query to see what parameter file is your database using currently. If it is PFILE or SPFILE.


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