Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
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 |
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.