differential_refresh_commit_after_max_operations
Use this system parameter to identify the number of rows comprising each transaction during a differential refresh.
Versions supported—CDC Replication Engine for Oracle databases version 10.2 and later
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