IS there a view where i can check whether an instance had been started using a pfile or an spfile?
select sys_context('USERENV','ORACLE_HOME') from dual;