Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Transaction Flushing

The TRANSACTION_FLUSH configuration options controls the aging of updated buffers based on the number of times a buffer has been updated since it was last flushed.

TRANSACTION_FLUSH <num_updates> sets the maximum number of updates made to a data or index cache page before it is flushed. The default value is 500000. Increasing this value reduces repeated flushing of updated cache pages that may occur in a system that maintains a high transaction rate with a pattern involving frequently updating the same buffers.