init file or spfile

[seyiisq]

pls how do i know if i am using initfile or spfile to start my instance

[dbasan]

You can type in sqlplus:

show parameter spfile

If its set it would give you the path else "unknown show option" error, similarly try with pfile.

I got this when i googled, give a try next time

select decode(count(*), 1, 'spfile', 'pfile' ) from v$spparameter where rownum=1 and isspecified='TRUE';
-courtesy TomKyte

This would be usefull for all who needs.

[seyiisq]

thanks it worked

[Balki]

SQL> show parameter spfile
this is faster

[davey23uk]

SQL> show parameter spfile
this is faster

why put the same thing someone else has already answered with?