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;

Note:
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= FROM PFILE=;