Managed SPFILE parameters in Oracle

SPFILE means Server Parameter File and is in binary format.
You cannot edit this SPFILE with a normal editor.
Instead, use the ALTER command or create a new file from a 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='location' FROM PFILE='location';