alter system中scope的区别:
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.
http://space.itpub.net/11946422/viewspace-666514
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24902180/viewspace-742078/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24902180/viewspace-742078/