How to check whether Oracle instance is started using pfile or spfile?

database, oracle

Solution

This shows database was started by `spfile`

SQL> show parameter spfile;

NAME    TYPE    VALUE
----    ----   ----------------------------------------------------------
spfile  string /root/apps/oracle/10g/dbs/spfile<DB_NAME>.ora

No values returned means that its started by `pfile`.

Problem

IS there a view where i can check whether an instance had been started using a pfile or an spfile?

Original source