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.

Note:

1. This parameter was introduced in 11g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = 'COMMIT_WAIT';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
archive_lag_target	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Maximum number of seconds of redos the standby could lose

Oracle initializatoin parameters