ITPub博客

首页 > Linux操作系统 > Linux操作系统 > HOWTO--如何區分一個初始化參數是靜態還是動態的(zt)

HOWTO--如何區分一個初始化參數是靜態還是動態的(zt)

原创 Linux操作系统 作者:vongates 时间:2019-01-07 20:36:07 0 删除 编辑
在Oracle中,從9i開始引入了spfile,也就是服務 器端初始化參數,有很多是可以支持在線修改的,也就是修改會馬上生效,詳細內容看下面的說明:

The ISSYS_MODIFIABLE column in V$PARAMETER tells us whether the parameters are static or dynamic. Static parameters require the instance to be restarted while dynamic parameters can take effect immediately upon being changed.

SQL> select distinct issys_modifiable from v$parameter;
 
ISSYS_MODIFIABLE
---------------------------
DEFERRED
FALSE
IMMEDIATE

If the ISSYS_MODIFIABLE value is set to FALSE for a parameter, it means that the parameter cannot change its value in the lifetime of the instance; the database needs to be restarted for changes to take effect. A parameter set to IMMEDATE value means that it is dynamic and can be set to change the present active instance as well as future database restarts. A parameter set to DEFERRED is also dynamic, but changes only affect subsequent sessions, currently active sessions will not be affected and retain the old parameter value.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51798/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    292677