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
Real Application Clusters	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.

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_LOGGING’;

Oracle initializatoin parameters