By default Database starts using spfile .But is there any way to findout whether db have been started using spfile or init.ora .
Printable View
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.
Thanks