By default Database starts using spfile .But is there any way to findout whether db have been started using spfile or init.ora .
in 9i do
SQL> show parameter spfile.
if the value is blank then the instance has started using pfile, else it will show the absolute path of the spfile it has used during startup.
"There is a difference between knowing the path and walking the path."