判断参数到底是动态的还是静态的,我们一般可以通过v$parameter视图来查看:
select name,value,ISSES_MODIFIABLE,issys_modifiable from v$system_parameter;
这里有两个列isses_modificable和issys_modifiable 分别对应的是session级别修改的参数和system级别修改的参数。
如果isses_modificable=true,表明这个参数可以在session级别可以修改,并且立即生效。false就是不能修改了。
可以使用alter session修改.
对于issys_modifiable的取值我们可以通过下面的一段文字来表述
select name,issys_modifiable from v$parameter
IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
DEFERRED - 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.
FALSE - 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.
select name,value,ISSES_MODIFIABLE,issys_modifiable from v$system_parameter;
这里有两个列isses_modificable和issys_modifiable 分别对应的是session级别修改的参数和system级别修改的参数。
如果isses_modificable=true,表明这个参数可以在session级别可以修改,并且立即生效。false就是不能修改了。
可以使用alter session修改.
对于issys_modifiable的取值我们可以通过下面的一段文字来表述
select name,issys_modifiable from v$parameter
IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
DEFERRED - 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.
FALSE - 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.
编辑回复