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

Viewed 79487

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

3 Answers
select sys_context('USERENV','ORACLE_HOME') from dual;
Related