当使用spfile时,不用重启就能生效的初始化参数,可以通过v$parameter.ISSYS_MODIFIABLE字段来判断。
v$parameter.ISSYS_MODIFIABLE参数
Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:
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.
sys@RACDB>select distinct ISSYS_MODIFIABLE from v$parameter;
ISSYS_MODIFIABLE
------------------------------
IMMEDIATE
FALSE
DEFERRED
ys@RACDB>select name,ISSYS_MODIFIABLE from v$parameter where name='statistics_level';
NAME ISSYS_MODIFIABLE
------------------------------ ------------------------------
statistics_level IMMEDIATE
sys@RACDB>select name,ISSYS_MODIFIABLE from v$parameter where name='processes';
NAME ISSYS_MODIFIABLE
------------------------------ ------------------------------
processes FALSE
sys@RACDB>select name,ISSYS_MODIFIABLE from v$parameter where name='sort_area_size';
NAME ISSYS_MODIFIABLE
------------------------------ ------------------------------
sort_area_size DEFERRED
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/628922/viewspace-716075/,如需转载,请注明出处,否则将追究法律责任。