COMMIT_LOGGING


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.