Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?
Date: Mon, 14 Apr 2008 01:35:35 -0700 (PDT)
Message-ID: <51b0b607-cd04-4b14-91d2-80a30b17d3cc@y18g2000pre.googlegroups.com>
On Apr 14, 12:07 pm, rgvguplb <rgvgu..._at_gmail.com> wrote:
> On Apr 13, 8:50 pm, Woody Ling <woodyl..._at_gmail.com> wrote:
>
> > I find that many spfile and pfile coexist in one system. How do I know
> > which one is used by the DBA to startup the database?
>
> > If the database is started, I can type "show parameter spfile" to
> > check the location of spfile. But it show nothing if pfile is used.
> > Besides, any way or log files to check which one is used last time if
> > database is down?
>
> > Thanks.
> > Woody Ling
> > Hong Kong
>
> you MAY be able to get a clue from the alert log as well, but not too
> sure.
You can't get the answer what you want.The best way is to delete unused pfile and spfile on the database. Received on Mon Apr 14 2008 - 03:35:35 CDT