Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?

On Apr 14, 4:35 pm, blueprinc..._at_gmail.com wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -

Yes, but first of all I need to know which pfile is in used. Are there any entries in the trace log file indicate which pfile was just used to startup the database? Received on Mon Apr 14 2008 - 03:45:00 CDT