Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

COMMIT_DELAY_BASE

COMMIT_DELAY_BASE <cohort size measure>

For advanced control of the intricate commit delay timing statistics, additional controls are available for the commit delay time calculation.

The cohort size measure determines the rate at which the nominal commit delay time is adjusted as the number of cohorts increases or decreases. Increasing this value tends to reduce the amount of change in the blocking time as the number of cohorts changes.

It is recommended that these values be carefully profiled as they can impact performance in many unexpected ways.

Default: 50

See Also

COMMIT_DELAY

COMMIT_DELAY_SCALE

COMMIT_DELAY_USEC

TOCIndex