In When learning Oracle, we will find that many of Oracle's knowledge points are in pairs.
So, in order to facilitate understanding and memory, I will make a summary of this series.
The first part of this series is:
Is the initialization parameter static or dynamic?
In Oracle, spfile is introduced from 9i. Many parameters support online modification, that is, the modification will take effect immediately.
The official documentation provides the following instructions:
The issys_modifiable column in V $ parameter tells us whether the parameters are static or dynamicstatic parameters require the instance to be restarted while dynamic parameters can take effect immediately upon being changed
Check the value of issys_modifiable:
Sys @ orcl> select distinct issys_modifiable from V $ parameter; ISSYS_MOD---------IMMEDIATEFALSEDEFERRED
Parameter value description:
● False: If issys_modifiable is changed to this value, the parameter is static.
● Immediate: Indicates that the parameter is dynamic, can be modified online, and takes effect online.
● Deferred: This parameter is dynamic. However, the modification is invalid in the current session and takes effect only for the next session.