How to check oracle database open using SPFILE or PFILE?

Dear Friends,

If your Production database or any testing database is running and you want to know which file was used by database when it was started? you want to know when database open what file used by database spfile of pfile.

you can startup or open your database using spfile or pfile. you check this using below query what file used by oracle database when it start or open.

Using below query you find whether your database started using SPFILE or PFILE.

Run query using sys user on oracle 9i, 10g, 11g, 12c database.

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

Pfile

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

spfile

Please give your expert comment if any.