OracleDB‎ > ‎

Init file

Oracle Database init file or startup file

Find if the Oracle database was started with pfile or spfile:

SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';

Comments