Contents Index DEFAULT_TIMESTAMP_INCREMENT option [database] DELAYED_COMMITS option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

DELAYED_COMMIT_TIMEOUT option [database]


Function 

Determines when the server returns control to an application following a COMMIT.

Allowed values 

Integer, in milliseconds.

Scope 

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

Default 

500

Description 

This option has meaning only when DELAYED_COMMITS is set to ON. it governs when a COMMIT entry in the transaction log is written to disk. With DELAYED_COMMITS set to ON, the database engine waits for the number of milliseconds set in the DELAYED_COMMIT_TIMEOUT option for other connections to fill a page of the log before writing the current page contents to disk.

For more information, see DELAYED_COMMITS option [database].


Contents Index DEFAULT_TIMESTAMP_INCREMENT option [database] DELAYED_COMMITS option [database]