Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?
From: rgvguplb <rgvguplb_at_gmail.com>
Date: Sun, 13 Apr 2008 21:03:32 -0700 (PDT)
Message-ID: <b7f42fe3-dea8-48b8-b8b6-b4426b1ba5f9@p25g2000pri.googlegroups.com>
Date: Sun, 13 Apr 2008 21:03:32 -0700 (PDT)
Message-ID: <b7f42fe3-dea8-48b8-b8b6-b4426b1ba5f9@p25g2000pri.googlegroups.com>
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
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