After you set nrm_thread to on, use the exec_nrm_request_limit parameter with configure replication server or alter connection to specify the total amount of memory available to RepAgent Executor thread for the message queue the NRM threads.
If the total amount of memory used by commands on the message queue is larger than than what you specify with exec_nrm_request_limit, the RepAgent Executor thread sleeps,and waits for memory to become available. As the NRM thread processes commands on the message queue, it frees the memory for the RepAgent Executor thread.
alter connection to SYDNEY_DS.pubs2 set exec_nrm_request_limit to ‘1073741824’
exec_nrm_request_limit values:
After you change the configuration for exec_nrm_request_limit, suspend and resume the Replication Agent. To suspend and resume: