Re: how to find if instance started by pfile or spfile

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 24 Apr 2007 22:42:30 +0200
Message-ID: <462E6BB6.2090407@gmail.com>

esthershensh_at_yahoo.com schrieb:
> Hi,
>
> I have a very stupid question to ask..
>
> is there any way to find which parameter file started the oracle
> instance?
>
> For example, is that pfile or spfile? location of the file ?
>
> can I find those info from dictionary views ?
>
> your help is very appreciated.
>
> Thanks.
>

Your question is a little bit vague,provided the fact that a pfile can have location to spfile as valid parameter, in that case, values will be taken from both, pfile and spfile.

But you probably are interested in v$parameter.isdefault='FALSE' and v$spparameter.isspecified='TRUE'

Best regards

Maxim Received on Tue Apr 24 2007 - 15:42:30 CDT