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)
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
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