setBatchSize Procedure

This procedure changes the batch size used during DML operations. When performing inserts, updates, or deletes, batching the operations so that they are not executed as separate statements will result in performance gains. However, more memory is needed to buffer all the bind values. When batching is used, a commit occurs only after a batch is executed. Therefore, if one of the statements inside a batch fails, the whole batch is rolled back. If this behavior is unacceptable, set the batch size to 1.

Syntax

DBMS_XMLSAVE.setBatchSize (

ctxHdl     IN ctxType, 
batchSize  IN NUMBER);

Parameters

Table 73-7 shows the parameters of the setBatchSize procedure.

Table 73-7 setBatchSize Procedure Parameters

Parameter	Description
ctxHdl (IN)	The context handle.
batchSize (IN)	The batch size.