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

On Apr 24, 3:00 pm, sybra..._at_hccnet.nl wrote:
> On 24 Apr 2007 11:56:35 -0700, esthershe..._at_yahoo.com wrote:
>
> >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.
>
> Doc question, which also has been ask before.
>
> Show parameter spfile
>
> Will show the location of the spfile when started by spfile, will be
> NULL when started by pfile.
> Easy and ALL documented.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks for your reply. I tried it works. In my enviornment, it is null , so I suppose it's PFILE.

but it comes out another question, now I know it is PFILE, but where is the PFILE, the location?

appreciated. Received on Mon Apr 30 2007 - 15:37:21 CDT