SPLIT_TRANS_RECS

Valid For

Parallel Replicat

Description

Specifies that large transactions should be broken into pieces of specified size and applied in parallel. Dependencies between pieces are still honored. Disabled by default.

The use of SPLIT_TRANS_RECS in the presence of foreign keys on the target tables may cause constraint violation errors, if the parent and child rows are in different splits, as each split is committed separately. So, SPLIT_TRANS_RECS should not be used in the presence of foreign keys on the target tables.

For online migration use cases, where the application is not active on the target database, you may consider to disable the foreign keys during the online migration and use SPLIT_TRANS_RECS. The foreign keys can be re-enabled before the application switchover to the target database.

Syntax

SPLIT_TRANS_RECS value

Example

SPLIT_TRANS_RECS 100000