ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle参数修改后的生效判定

Oracle参数修改后的生效判定

原创 Linux操作系统 作者:lwitpub 时间:2012-02-11 20:47:49 0 删除 编辑
当使用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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-08

  • 博文量
    107
  • 访问量
    379412