|Default value||If this parameter is not explicitly specified, then database commit behavior defaults to writing commit records to disk before control is returned to the client.
Be aware that the
|Modifiable||Yes (at both session-level and system-level). Values supplied for
|Range of values||Single-quoted, comma-separated list of either
|Oracle RAC||Each instance may have its own setting|
COMMIT_WRITE is an advanced parameter used to control how redo for transaction commits is written to the redo logs. The
BATCH options control how redo is batched by Log Writer. The
NOWAIT options control when the redo for a commit is flushed to the redo logs.
COMMIT_WRITEparameter is deprecated. It is retained for backward compatibility only. It is replaced by the