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
This would be usefull for all who needs.
select decode(count(*), 1, 'spfile', 'pfile' ) from v$spparameter where rownum=1 and isspecified='TRUE';
Last edited by dbasan; 06-13-2007 at 04:49 PM.
SQL> show parameter spfile
this is faster
why put the same thing someone else has already answered with?
Originally Posted by Balki
Click Here to Expand Forum to Full Width