Controlling the number of outstanding bytes

Database connection configuration parameters: exec_sqm_write_request_limit and md_sqm_write_request_limit

exec_sqm_write_request_limit controls the maximum number of outstanding bytes the RepAgent User thread can hold before it must wait for some of those bytes to be written to the inbound queue. Similarly, md_sqm_write_request_limit controls the number of outstanding bytes a DIST thread can hold before it must wait for some of those bytes to be written to the outbound queue.

Monitor the number of times and duration of time the RepAgent Executor sleeps while waiting for outstanding write requests to complete by reviewing this counter:

If the RepAgent Executor consistently reaches this threashold, review the StableDevice I/O.