Enables the distributor (DIST) thread to read SQL statements directly from the Stable Queue Thread (SQT) cache. This reduces the workload from SQT and the dependency between the two, and improves the efficiency of both SQT and DIST.
Use the dist_direct_cache_read parameter with configure replication server to use this enhancement:
configure replication server set dist_direct_cache_read to ‘on’
By default, dist_direct_cache_read is set to ‘off’. If you disable the parameter, the distributor thread requests SQL statements from SQT through the message queue. This leads to inbound and outbound queue contention.
dist_direct_cache_read is a server-level parameter. You must restart Replication Server after you enable or disable the parameter.