LOOK_AHEAD_TRANSACTIONS
Valid For
Parallel Replicat
Description
It controls how far ahead the Scheduler looks when batching transactions. The benefit and value to set this parameter at is highly dependent on the amount of data typically that has is in the trail files that Replicat is reading, and depends on the transaction mix. So, different values may work better or worse in a specific environment. Generally increment or decrement the parameter in 10,000 interval until the best throughput is achieved.
Default
The default value is 10000.
Syntax
LOOK_AHEAD_TRANSACTIONS