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:03:32 -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

I think by default oracle will use the SPFILE that corresponds to your ORACLE_SID. In 10g, at least, the SPFILE is used by default, unless you've changed it. Received on Sun Apr 13 2008 - 23:03:32 CDT

Original text of this message