Gives the agent used to write data a hint as to the number of rows that should be inserted into the database in each batch. Batching the inserts reduces the number of network round trips and helps the database maximize its performance. If the batch size is too large, you may encounter memory issues.
Note: Without hints, the agent will determine the fetch and batch sizes based on it’s memory settings.
/*+ FORCE_BATCHSIZE(NumberOfRows) */
- NumberOfRows: A numeric of type BIGINT which specifies the forced rowcount. This number should be greater than or equal to zero.
Generally after the first statement keyword, e.g.:
INSERT /*+ FORCE_BATCHSIZE(1000) */ INTO ... ; DATACOPY /*+ FORCE_BATCHSIZE(1000) */ source TO target ; SYNC /*+ FORCE_BATCHSIZE(1000) */ target TO source ;