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.

Syntax

/*+ FORCE_BATCHSIZE(NumberOfRows) */

Arguments

  • NumberOfRows: A numeric of type BIGINT which specifies the forced rowcount. This number should be greater than or equal to zero.

Hint Placement

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 ;