mirror_interim_commit_threshold

By default, CDC Replication guarantees transactional delivery of change data to the target. This ensures that if any data from a source transaction is committed to the target, then all other in scope operations from that source transaction are committed as well.

In cases where large transactions are done on the source system, it can be more efficient to break a large transaction into smaller transactions when applying data to the target. You can configure this behavior using this system parameter.

Applies to

Target datastores

Minimum Setting

0

A value greater than 0 indicates that you want CDC Replication to break up large transactions into smaller transactions. For example, a value of 2000 indicates that CDC Replication will split up large source transactions so that each transaction committed to the target database contains no more than 2000 operations.

Default Setting

0

The default value of 0 for this system parameter indicates that the product guarantees transactional delivery of change data to the target.