Oracle Dynamic static Parameter modification rules

Sql> Select name,value,isses_modifiable (Parameters modified at session level), issys_modifiable (parameters modified at the system level)
2 from V$parameter
3 where name= ' max_dump_file_size ';

Sql>alter system Reset _allow_resetlogs_corruption scope=spfile sid= ' * ';

If isses_modifiable=true, it indicates that this parameter can be modified at the session level and takes effect immediately.

Sql>alter session Set Xxx=xxx;

Sql>alter system set xxx=xxx scope=xxx;

Scope parameter Description:

Static parameters must be specified as scope
Dynamic parameter issys_modifiable is immediate without scope the default is both

Dynamic parameter issys_modifiable for deferred must add Scope=spfile or add derferred

Parameter type	SPFile	Memory	Both	Deferred
Static parameter (Issys_modifiable = False)	Yes, restart the server to take effect	No	No	No
Dynamic parameters (Issys_modifiable is immediate)	Yes, restart the server to take effect	Yes, immediate effect, restart service failure	Yes, effective immediately, restarting the server still works	OK
Dynamic parameters (Issys_modifiable is deferred)	Yes, restart the server to take effect	No	No	Yes, the new session is valid

Oracle Dynamic static Parameter modification rules