init file or spfile

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

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 :)

Code:

---

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.

thanks it worked

SQL> show parameter spfile
this is faster

Quote:

---

Originally Posted by Balki

SQL> show parameter spfile
this is faster

---

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