Oracle 参数 COMMIT_LOGGING 官方解释，作用，如何配置最优化建议
本站中文解释
COMMIT_LOGGING：定义是否提交日志记录。如果设置为TRUE，用户可以强制Log Writer进程在提交操作时记录提交前系统状态和数据变化，如果设置为FALSE，则取消记录提交操作的功能，仅记录commit操作时间，可以增加系统性能。
正确设置：
通过ALTER SYSTEM配置：
ALTER SYSTEM SET COMMIT_LOGGING = TRUE | FALSE;
通过SPFILE PCONFIG配置：
ALTER SYSTEM SET COMMIT_LOGGING=TRUE SCOPE=spfile;
保存并重启系统：
SHUTDOWN IMMEDIATE;
STARTUP;
官方英文解释
COMMIT_LOGGING is an advanced parameter used to control how redo is batched by Log Writer.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
There is no default value. |
|
Modifiable |
Yes (at both session-level and system-level) |
|
Modifiable in a PDB |
Yes |
|
Basic |
No |
|
Oracle RAC |
Each instance may have its own setting |
If COMMIT_LOGGING is altered after setting COMMIT_WAIT to FORCE_WAIT, then the FORCE_WAIT option is no longer valid.
