Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find out WHAT PFILE IS USED?

618845Feb 22 2009 — edited Feb 23 2009

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.

but what about pfile?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2009

Added on Feb 22 2009

#general-database-discussions

5 comments

2,555 views