| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
| Property | Description | 
|---|---|
| Parameter type | String | 
| Syntax | COMMIT_LOGGING = { IMMEDIATE | BATCH } | 
| Default value | There is no default value. | 
| Modifiable | Yes (at both session-level and system-level) | 
| Basic | No | 
| Oracle RAC | Each instance may have its own setting | 
COMMIT_LOGGING is an advanced parameter used to control how redo is batched by Log Writer.
If COMMIT_LOGGING is altered after setting COMMIT_WAIT to FORCE_WAIT, then the FORCE_WAIT option is no longer valid.