【oracle笔记】scope参数

SCOPE子句及说明

 

SCOPE 子句	说明
SCOPE = SPFILE	只更改服务器参数文件中的参数。更改在下次启动时生效，对于静态参数也有效。
SCOPE = MEMORY	只更改内存中的参数。只作用于动态参数，更改立即生效。因为没有更新服务器参数文件，所以更改不能永久保留。
SCOPE = BOTH	只对动态参数有效，更改立即生效并且永久保留。

 

如果使用SPFILE服务器参数文件启动的实例，默认设置为 SCOPE = BOTH;

如果使用PFILE文本参数文件启动的实例，默认设置为 SCOPE = MEMORY;

 

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.