mirror_commit_on_transaction_boundary

Use this system parameter to indicate whether or not the commits that CDC Replication does on the target will always correspond with a commit that occurred on the source database.

Versions supported—CDC Replication Engine for Iceberg version 10.2 and later

If you choose to ignore the commitment control of the source database, CDC Replication allows you to see the partial results of large transactions.

Values

Set this parameter to one of the following values:

true: Does not ignore the commitment control of the source database. Only records in a committed transaction are mirrored to the target. This setting provides true transaction consistency by ensuring that only committed transactions are sent to the target.
false: Ignores the commitment control of the source database. This value disables commitment control for transaction processing. No attempt to maintain transaction consistency is performed during mirroring.

Applies to

Target datastores

Default Setting

True