Contents Index CONVERSION_ERROR option [compatibility] COOPERATIVE_COMMITS option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

COOPERATIVE_COMMIT_TIMEOUT option [database]


Function 

Governs when a COMMIT entry in the transaction log is written to disk.

Allowed values 

Integer, in milliseconds

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

250

Description 

This option has meaning only when COOPERATIVE_COMMITS is set to ON. The database server waits for the specified number of milliseconds for other connections to fill a page of the log before writing to disk. The default setting is 250 milliseconds.


Contents Index CONVERSION_ERROR option [compatibility] COOPERATIVE_COMMITS option [database]