fastload_refresh_commit_after_max_operations
Use this system parameter to specify the maximum number of rows that CDC Replication can place in an array and apply to the target database during refresh or mirroring.
Versions supported—CDC Replication Engine for Oracle databases (Trigger edition) version 10.2 and later
To reduce the workload on the target database during refresh, CDC Replication periodically commits the changes to the target database rather than performing the refresh as a single large transaction.
- Applies to
- Target datastores
- Minimum Setting
- 1
- Maximum Setting
- 2147483647
- Default Setting
- 1000