Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

COMMIT_DELAY_SCALE

COMMIT_DELAY_SCALE <ratio of block to clear time>

For advanced control of the intricate commit delay timing statistics, additional controls are available for the commit delay time calculation. The ratio of block to clear time cannot be smaller than 1. As this value increases, the amount of time waiting to permit commit delay cohorts to flow past their mutual block is decreased.

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

Default: 2

See Also

COMMIT_DELAY

COMMIT_DELAY_BASE

COMMIT_DELAY_USEC

TOCIndex