ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle修改初始化参数(initialization parameter)scope的选项

Oracle修改初始化参数(initialization parameter)scope的选项

原创 Linux操作系统 作者:keeptrying 时间:2012-06-11 08:34:44 0 删除 编辑

Use the SET clause of the ALTER SYSTEM statement to set or change initialization parameter values. The optional SCOPE clause specifies the scope of a change as described in the following table:

SCOPE Clause

Description

SCOPE = SPFILE

The change is applied in the server parameter file only. The effect is as follows:

  • For dynamic parameters, the change is effective at the next startup and is persistent.
  • For static parameters, the behavior. is the same as for dynamic parameters. This is the only SCOPE specification allowed for static parameters.

SCOPE = MEMORY

The change is applied in memory only. The effect is as follows:

  • For dynamic parameters, the effect is immediate, but it is not persistent because the server parameter file is not updated.
  • For static parameters, this specification is not allowed.

SCOPE = BOTH

The change is applied in both the server parameter file and memory. The effect is as follows:

  • For dynamic parameters, the effect is immediate and persistent.
  • For static parameters, this specification is not allowed.

 

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

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

注册时间:2011-04-25

  • 博文量
    130
  • 访问量
    911961