Managed SPFILE parameters in Oracle
SPFILE stands for Server Parameter file. It is in binary format.
You cannot modified this SPFILE with normal editor.
You can edit through commands ALTER or Create new file from pfile.
Default location of SPFILE:
UNIX or LINUX : $ORACLE_HOME/dbs
WINDOWS : %ORACLE_HOME%\database
Check the location of SPFILE
show parameter spfile
Check the parameter value which is able to modified
SELECT issys_modifiable from v$parameter;
DEFERRED: it is also dynamic but changes only affect at new session, already connected old session remains same
FALSE: its means parameter cannot change its value in lifetime of instance.
IMMEDIATE: It is dynamic and set to be change active instance as well as DB restart.
Change parameter of SPfile
ALTER SYSTEM SET = SCOPE= DEFERRED SID=;
Create SPFILE from PFILE
CREATE SPFILE FROM PFILE;
CREATE SPFILE='location' FROM PFILE='location';