How to check whether database whether it is opened by pfile/spfile.

Kapil Relan

 Profile Answers by Kapil Relan Questions by Kapil Relan

• Apr 15th, 2011

if you are not aware about what your database has chosen at startup ie PFILE or SPFILE you can simply try the following SQL statement:,which i tried create spfile from pfile;if you get the output that...

clevelcd

 Profile Answers by clevelcd Questions by clevelcd

• Jun 5th, 2008

Another alternative: SHOW PARAMETER SPFILE;

Answer Question  Select Best Answer