| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| 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 |
| Real Application Clusters | 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.