Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to find if instance started by pfile or spfile
esthershensh_at_yahoo.com schrieb:
> On Apr 24, 4:42 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> > Thanks for your reply. I took a look at those V$s, I'm afraid I did > not get what mean, could you give me an example for it ? > > Thanks in advance. >
SELECT * FROM V$SPPARAMETER WHERE ISSPECIFIED='TRUE'; would show you values taken from spfile, if any - then spfile was used to start instance.
If the query above return no rows, then
SELECT * FROM V$PARAMETER WHERE ISDEFAULT='FALSE' AND ISMODIFIED='FALSE'
will show values specified in pfile (well, there may be as well
specified default values, but it doesn't make sense at least for me).
For most configurations that should be enough to see, whether pfile or spfile was used (or you can use advice given you by Sybrand as well).
Best regards
Maxim Received on Mon Apr 30 2007 - 17:01:51 CDT