Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

LOG_TEMPLATE_COPY_SLEEP_PCT

LOG_TEMPLATE_COPY_SLEEP_PCT <percent>

When working with large log templates on high volume systems, the log template copy operation can consume excessive I/O time impacting performance. By periodically deferring the copy operation, this can smooth out I/O spikes. This option, when used with the LOG_TEMPLATE_COPY_SLEEP_TIME option specifies the percentage of data that is written to the target transaction log file after which the copy operation sleeps for the number of milliseconds specified for the LOG_TEMPLATE_COPY_SLEEP_TIME option.


Default: 15
Minimum value: 1
Maximum value: 99

See Also

TOCIndex