differential_refresh_commit_after_max_operations
Use this system parameter to identify the number of rows comprising each transaction during a differential refresh.
To reduce the workload on the target database during differential refresh, CDC Replication periodically commits the changes to the target database rather than performing the differential refresh as a single large transaction.
- Applies to
- Target datastores
- Minimum Setting
- 1
- Maximum Setting
- 2147483647
- Default Setting
- 100