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

On Apr 24, 4:42 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> esthershe..._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

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. Received on Mon Apr 30 2007 - 15:40:48 CDT