
If there is a lot of bandwidth consumption by some of this miscellaneous traffic, round trip times could be degraded periodically on the network.This has two important implications that we should consider. One important aspect to keep in mind is that it is probable that the WAN is shared by other traffic (e-mail, data replication, san replication). Use tools like Iperf to test the transfer speeds that your network is capable of achieving. Customers often run into trouble when Auto Negotiation causes some NIC’s to set the transfer speeds to 1GigE because of configuration mismatches. After setup, run the configuration display utilities and ensure that all these component levels the transfer speeds are set to be 10 GigE.
#BANDWIDTH DELAY PRODUCT FULL#
So if you have a WAN that is a 10GigE network, all the NIC’s (Network interface cards), ports, switches in the configuration should be configured to support 10GigE full Duplex settings. We have to start by setting up the networking components to support the desired/stated bandwidth. If we set the Tcp Window size equal to the bandwidth delay product, then in theory we should be able to fully utilize the available bandwidth. If the senders output bandwidth is stable, and the bandwidth is fully used, then the BDP calculates the number of packets in transit. This is the amount of data that left the sender before the first acknowledgement was received by the sender. Once Tcp Window size amount of bytes are send, the sender stops sending any more bytes and waits for an acknowledgement from the receiver.īandwidth delay product is calculated as the product of the network bandwidth and network round trip time. Tcp Window size is the amount of bytes that can be transmitted without receiving an acknowledgement from the other side. To understand network data transfer throughput, It is important to understand the the concepts of Tcp Window Size and Bandwidth Delay Product (aka BDP). So it is very important to maintain low round trip times on your Wide area network.

Higher the network round trip time (aka latency), lower your data transfer throughput. One key point to keep in mind is that, lower the network round trip time (aka latency), higher your data transfer throughput.

If sufficient network bandwidth is not available with reasonable latencies, then we will start seeing the log transfer and apply,lagging on the standby site (Which is oracle speak for, your primary and standby database is now out of sync from a data perspective). We have to ensure that all the components from the source to target are setup correctly to ensure that the data transfer can be done with the best throughput possible. Log Transport Services, transfers Large volumes of redo logs from the primary location to the standby, using Sql*Net. Typically, in such deployments, the primary databases and standby databases are in geographically separate locations connected via a WAN (Wide Area Network). Oracle customers use Oracle Active Dataguard to create and maintain one or many standby databases that protect their mission critical primary databases from disaster.
