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

From: Woody Ling <>
Date: Sun, 13 Apr 2008 20:50:14 -0700 (PDT)
Message-ID: <>

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?

Woody Ling
Hong Kong Received on Sun Apr 13 2008 - 22:50:14 CDT

Original text of this message