Oracle参数修改后的生效判定

当使用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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/628922/viewspace-716075/