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

From: rgvguplb <>
Date: Sun, 13 Apr 2008 21:07:46 -0700 (PDT)
Message-ID: <>

On Apr 13, 8:50 pm, Woody Ling <> 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. Received on Sun Apr 13 2008 - 23:07:46 CDT

Original text of this message