Oracle修改初始化参数（initialization parameter）scope的选项

最新推荐文章于 2021-04-14 00:56:25 发布

cuigaijiao2361

最新推荐文章于 2021-04-14 00:56:25 发布

阅读量148

点赞数

文章标签：数据库

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

转载于:http://blog.itpub.net/25744374/viewspace-732428/