Enabling dsi_cmd_prefetch reduces data replication latency which decreases the length of time that Replication Server waits for results from the replicate data server through the ct_results routine, and subsequently reduces the length of time the data server waits for Replication Server.
dsi_cmd_prefetch works by :
Set dsi_cmd_prefetch on with alter connection or create connection.
alter connection to SYDNEY_DS.pubs2 set dsi_cmd_prefetch to ‘on’
Default: off.
dsi_cmd_prefetch is a dynamic parameter. You need not suspend and resume the database connection after you enable the parameter for the change to take effect.
If you also tune your data server to enhance performance, you may gain an additional performance increase when you enable dsi_cmd_prefetch.