DanBrother的部落格

Checking Which File Type (PFILE or SPFILE) Has Been Used for Starting Up the Database:

Method 1:
select decode(value,null,'PFILE','SPFILE') as "Initial File Type"
from sys.v_$parameter
where name = 'spfile';

Initial File Type
----------------------
SPFILE

Method 2:
select count(*)  as "Total Count"
from v$spparameter
where value is not null;
=> if the value of "Total Count" is greater than zero (>0), then SPFILE was used for starting up the database.