The SYNC_TABLE_IN_DOC procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| MAX_MINUTES | The maximum number of minutes that the synchronization process will
be allowed to begin processing a new batch of rows. If MAX_MINUTES is greater than 0 then a check will take place to determine if time (MAX_MINUTES) has expired before each new batch of rows is fetched for processing. The default value is defined in the DEFAULT_MAX_MINUTES column of the IN_DB_UPGRADE_CONTROL_SYNC table. The default value of 0 is equal to unlimited which means synchronization will continue until all rows in the SYNC_STAGE_DOC table have been processed and the source and destination tables are fully synchronized. |
| BATCH_SIZE | The batch size defines the number of rows to fetch (BULK COLLECT)
into the synchronization work queue (cursor) for each batch. The default value is defined in the DEFAULT_BATCH_SIZE column of the IN_DB_UPGRADE_CONTROL_SYNC table. The default value is 50,000 rows. |
| BULK_LIMIT | The bulk limit on the number of rows fetched from the cursor by the
bulk collect operation. This helps reduce the memory utilization (PGA)
for the process. The default value is defined in the DEFAULT_BULK_LIMIT column of the IN_DB_UPGRADE_CONTROL_SYNC table. The default value is 10,000 rows. |