1.46 COMMIT_WRITE
COMMIT_WRITE
is an advanced parameter used to control how redo for transaction commits is written to the redo logs.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
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. If only If only Be aware that the |
Modifiable |
Yes (at both session-level and system-level). Values supplied for |
Modifiable in a PDB |
Yes |
Range of values |
Single-quoted, comma-separated list of either |
Basic |
No |
Oracle RAC |
Each instance may have its own setting |
The IMMEDIATE
and BATCH
options control how redo is batched by Log Writer. The WAIT
and NOWAIT
options control when the redo for a commit is flushed to the redo logs.
Note:
The COMMIT_WRITE
parameter is deprecated. It is retained for backward compatibility only. It is replaced by the COMMIT_LOGGING
and COMMIT_WAIT
parameters.