This content has been marked as final. Show 6 replies
The RTT time can be obtained by a simple ping to your standby server:
PING standby.example.org.uk (18.104.22.168): 56 data bytes
64 bytes from 22.214.171.124: icmp_seq=0 ttl=58 time=15.421 ms
64 bytes from 126.96.36.199: icmp_seq=1 ttl=58 time=15.482 ms
--- standby.example.org.uk ping statistics ---
2 packets transmitted, 2 packets received, 0% packet loss
round-trip min/avg/max/stddev = 15.421/15.451/15.482/0.031 ms
So the RTT number, for me to plug into the formula would be 15.451.
Please find below some info on how to calculate the BDP, hope this would help
TCP/IP buffer data into send and receive buffers while sending and receiving to or from lower and upper layer protocols. The sizes of these buffers affect network performance, as these buffer sizes influence flow control decisions.
The parameters specify sizes of socket receive and send buffers, respectively, associated with Oracle Net connections RECV_BUF_SIZE and SEND_BUF_SIZE.
Please note that some operating systems have parameters that set the maximum size for all send and receive socket buffers. You must ensure that these values have been adjusted to allow Oracle Net to use a larger socket buffer size.
Oracle recommends to set RECV_BUF_SIZE and SEND_BUF_SIZE three time the BDP’s value (Bandwidth delay product) in order to fully use network bandwidth over TCP protocol.
how to calculate RECV_BUF_SIZE and SEND_BUF_SIZE find below the details
Bandwidth= 10mbps=10 000 000 bits /s
Assume RTT=10ms=10/1000 (0.01s) ( RTT obtain through ping @server)
BDP= 10 Mbps * 10msec (0.01 sec) --à 10 ,000,000 * .01=100, 000bits/s Note: I took the worst RTT value=10ms
BDP= 100,000 / 8 = 12, 500 bytes
The optimal send and receive socket buffer sizes are calculated as follows:
Socket buffer size (RECV_BUF_SIZE and SEND_BUF_SIZE ) = 3 * bandwidth * delay = 12,500 * 3 = 37500 bytes