Oracle Goldengate: Tune TCPBUFSIZE and TCPFLUSHBYTES parameters.


The two RMTHOST parameters, TCPBUFSIZE and TCPFLUSHBYTES, are very useful for increasing the buffer sizes and network packets sent by Data Pump over the network from the source to the target system. This is especially beneficial for high latency networks.
It is recommended that you set these parameters to an initial value of 1MB (1,048,576 bytes) or the calculated value, whichever is larger.

Use the ping command to obtain the average round trip time (RTT).
For example: % ping Pinging [] with 32 bytes of data: Reply from bytes=32 time=31ms TTL=56 Reply from bytes=32 time=61ms TTL=56 Reply from bytes=32 time=32ms TTL=56 Reply from bytes=32 time=34ms TTL=56 Ping statistics for Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 31ms, Maximum = 61ms, Average = 45ms

Calculate the bandwidth-delay product (BDP):
For example, if the network between the source and target databases is 125 megabits per second (Mbits) and the latency is 45ms the calculation would be as follows: BDP = (125,000,000 / 8) * 0.045 = 703125bytes

Multiply the result by 4 to determine 4xBDP:
For example: 4xBDP = 703125 x 4 = 2812500
In this example, because the result is more than 1MB, set the values of TCPBUFSIZE and TCPFLUSHBYTES to 2812500
The parameters are set in the Data Pump parameter file. For example: RMTHOST ggtarget, MGRPORT 7810, TCPBUFSIZE 2812500, TCPFLUSHBYTES 2812500 

Note: The maximum socket buffer size for non-Windows systems is usually limited by default.

Catch Me On:- Hariprasath Rajaram

FB Group:
FB Page:

Leave a Reply

Your email address will not be published. Required fields are marked *