The change is applied in the server parameter file only. The effect is as follows:
For dynamic parameters, the change is effective at the next startup and is persistent.
For static parameters, the behavior. is the same as for dynamic parameters. This is the only SCOPE specification allowed for static parameters.
The change is applied in memory only. The effect is as follows:
For dynamic parameters, the effect is immediate, but it is not persistent because the server parameter file is not updated.
For static parameters, this specification is not allowed.
The change is applied in both the server parameter file and memory. The effect is as follows:
For dynamic parameters, the effect is immediate and persistent.
For static parameters, this specification is not allowed.
启动和修改方式
动态参数
静态参数
SPFILE
启动
Scope=spfile
更新spfile
更新spfile
重启后永久生效
重启后永久生效
Scope=memory
更新内存
不允许
立即生效，重启后无效
Scope=both(默认)
更新内存和spfile
不允许
立即并永久生效
PFILE
启动
Scope=spfile
不允许
不允许
Scope=memory（默认）
更新内存
不允许
立即生效，重启后无效
Scope=both
不允许
不允许
此字段含义：
- Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
- Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
- Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances
SQL>
ISSYS_MOD COUNT(*)
--------- ----------
IMMEDIATE 145
FALSE 107
DEFERRED 7