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

Question

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

Answer 1

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.