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