Friday, September 20, 2013

Calculation for Network Bandwidth Transfer for REDO LOG - Data Guard Environment

To calculate for Network Bandwidth Transfer for REDO LOG - Data Guard Environment in Primary database

Formula : 
========
Required bandwidth = ((Redo rate bytes per sec. / 0.7) * 8) / 1,000,000 = bandwidth in Mbps

Note : Assuming TCP/IP network overhead of 30%.

Calculation Ways:
==============
1. RUN Statspack during peak intervals to measure REDO rate.
2. If it is RAC instances, we have to calculate for all the RAC instances.
3. Check the following SQL Statement
    SQL> select * from v$sysmetric_history
               where metric_name = 'Redo Generated Per Sec';
4. RDA-Output:
    Performance - AWR Report - Statistic: "redo size"

Example :
========
Let us assume the redo rate is a 600 KB/sec.

Required bandwidth =

((Redo rate bytes per sec. / 0.7) * 8) / 1,000,000 = bandwidth in Mbps
= ((614400/0.7) * 8) /1,000,000
= 7.02 Mbps

No comments:

Post a Comment