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 reducing the number of network operations.
You can monitor the average size of a batch by referring to counter 57078 – DSIEBatchSizeAve. 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 refering to counter 57074 – DSIEBatchTimeAve.
The following counters may also be useful in monitoring the effectiveness of batching and batch size:
57037 – SendTimeLast |
57039 – SendTimeMax |
57041 – SendTimeAvg |
|---|---|---|
57063 – DSIEResultTimeLast |
57065 – DSIEResultTimeMax |
57067 – DSIEResultTimeAve |
57069 – DSIEBatch |
57070 – DSIEBatchTimeLast |
57072 – DSIEBatchTimeMax |
57076 – DSIEBatchSizeLast |
57077 – DSIEBatchSizeMax |
57079 – DSIEOCmdCountLast |
57080 – DSIEOCmdCountMax |
57081 – DSIEOCmdCountAve |
57092 – DSIEBFMaxBytes |
