-
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.
Last edited by dbasan; 06-13-2007 at 04:49 PM.
-
-
SQL> show parameter spfile
this is faster
-
Originally Posted by Balki
SQL> show parameter spfile
this is faster
why put the same thing someone else has already answered with?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|