How do I know which one is used to startup database by DBA if many spfile and pfile coexist?
Date: Sun, 13 Apr 2008 20:50:14 -0700 (PDT)
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?
Hong Kong Received on Sun Apr 13 2008 - 22:50:14 CDT