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
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