scope=memory scope=spfile scope=both
2024-07-21 02:52:03
供稿：網友
scope=memory;---直接修改內存中的值scope=spfile;---只改的磁盤上的參數，沒有更改內存scope=both;--同時修改內存和磁盤ALTER SYSTEM 中 SCOPE=SPFILE/MEMORY/BOTH 的區別：SCOPE = SPFILE The change is applied in theserverparameter 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 = MEMORYThe 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 = BOTHThe 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.（既寫入到初始化參數文件，也在內存上修改，立即生效。同樣也只適用于動態參數，靜態參數則不允許。）
