How to to Calculate TCP Socket Buffer Sizes
Tuesday, August 21, 2012



For Data Guard Physical Standby
Constants:
NIC BANDWITH = 10Gb Ethernet (10,000,000,000 bit)
ROUND TRIP TIME (RTT) = 3 ms (0.003 seconds)
Formula:
optimal socket buffer size = (bandwith delay product * 3)
bandwith delay product = (nic bandwith * round trip time)
optimal socket buffer size = ((10,000,000,000 * .003) * 3)
optimal socket buffer size = ((30,000,000) * 3)
optimal socket buffer size = 90,000,000 bit
90,000,000 bit / 8 = 11,250,000 bytes

 Sqlnet.Ora Parameters To Set If Broker Is Used
RECV_BUF_SIZE = 11250000
SEND_BUF_SIZE = 11250000

 If Broker Is Not Used Set On Listener.Ora
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)
(HOST=<hostname.domain>)(PORT=1521)
(RECV_BUF_SIZE = 11250000)
(SEND_BUF_SIZE = 11250000)))

 If Broker Is Not Used Set On Tnsnames.Ora
<dbname>=
(DESCRIPTION=
(RECV_BUF_SIZE = 11250000)
(SEND_BUF_SIZE = 11250000)
(ADDRESS=(PROTOCOL=tcp)
(HOST=<hostname.domain>)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=<dbaname>)))

at Tuesday, August 21, 2012  

Labels:

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)
Powered by Blogger.