Database connection configuration parameter: dsi_cmd_batch_size
dsi_cmd_batch_size controls the size of a DSI command batch. That is, it controls the size of the buffer a DSI uses to send commands to a replicate data server. When the DSI configuration batch is set on, the DSI places as many commands as will fit into a single command batch before sending it to the replicate. In some cases, increasing the value of dsi_cmd_batch_size improves throughput by providing the replicate database with more work per command batch.
You can monitor the average size of a batch by referring to counter 57076 – DSIEBatchSize. You can monitor the average amount of time taken to process a batch (the time from when the batch is created until it is flushed and the results processed) by referring to counter 57070 – DSIEBatchTime.
The following counters may also be useful in monitoring the effectiveness of batching and batch size:
57037 – SendTime |
57079 – DSIEOCmdCount |
57063 – DSIEResultTime |
|---|---|---|
57070 – DSIEBatchTime |
57092 – DSIEBFMaxBytes |
57076 – DSIEBatchSize |
