global_max_batch_size

CDC Replication collects rows and places them in an array (in memory) while receiving table-level operations from the source system. CDC Replication applies the rows from the array when there is a change to a different table, when there is a new table-level operation, or when the maximum number of rows in an array has been reached.

You can use this parameter during mirroring only if mirror_end_on_error is true and mirror_expected_errors_list is empty. Use only during a refresh if refresh_end_on_error is true and refresh_expected_errors_list is empty.

Before CDC Replication places rows into an array, it allocates memory for the maximum number of rows you specify and multiplies this integer by the maximum length of a row.

If the maximum number of rows is too large, then CDC Replication cannot allocate enough memory and will shut down. Management Console references this area to present replication latency information.

Applies to

Target datastores

Minimum Setting

1 row

Maximum Setting

2147483647 rows

Default Setting

25 rows