Oracle修改初始化引數（initialization parameter）scope的選項

keeptrying發表於2012-06-11
Oracle

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章