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.