arunbulls

 Profile Answers by arunbulls 

• May 19th, 2008

 

check this parameter

select value from v$parameter where name like 'spfile'

if it is empty you are using pfile .

clevelcd

 Profile Answers by clevelcd 

• Jun 5th, 2008

 

Another alternative: SHOW PARAMETER SPFILE;

Kapil Relan

 Profile Answers 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

ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance

then you can be sure that database used SPFILE at startup.
else
PFILE.