db started

[mdash]

By default Database starts using spfile .But is there any way to findout whether db have been started using spfile or init.ora .

[adewri]

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.

[mdash]

Thanks