Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

COMMIT_WAIT

Property Description
Parameter type String
Syntax COMMIT_WAIT = { NOWAIT | WAIT | FORCE_WAIT }
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_WAIT is an advanced parameter used to control when the redo for a commit is flushed to the redo logs.

If the parameter is set to FORCE_WAIT, the default behavior ( immediate flushing of the redo log buffer with wait) is used. If this is a system setting, the session level and transaction level (COMMIT_WRITE) options will be ignored. If this is a session level setting, the transaction level options will be ignored. If COMMIT_WAIT is altered after it has been set, then the FORCE_WAIT option is no longer valid.