Find which parameter file Oracle is using

When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?

Questions by mah_mca

Showing Answers 1 - 3 of 3 Answers

chaitra murthy

  • Jan 9th, 2009
 

The command given below will display 3 colums NAME, TYPE, VALUE
SQL> show parameter spfile
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string E:ORACLEPRODUCT10.1.0DB_1 DATABASESPFILEORCL.ORA

If in the value
column there is a path means database has opened using spfile.
If it is Null means database has opened using pfile.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions