Based on primary database's redo generation rate we need calculate the
required network bandwith.
How to calculate Redo rate.
Method 1:
We need run AWR report at periodic intervals. Please note down "Per Second" value. Take the highest
"Redo size" "Per Second" value from AWR report, and that is
your peak redo generation rate.
Load Profile
Per Second
|
Per Transaction
|
Per Exec
|
Per Call
|
|
DB Time(s):
|
0.7
|
0.1
|
0.00
|
0.00
|
DB CPU(s):
|
0.2
|
0.0
|
0.00
|
0.00
|
Redo size:
|
171,813.4
|
15,421.0
|
||
Logical reads:
|
6,451.7
|
579.1
|
Method 2:
Query
v$sysmetric_history view to find redo generation per second.
select avg (value) from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';
select avg (value) from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';
The formula used for calculation the network bandwidth is:
Required bandwith = ((Redo rate bytes per sec./0.7)*8) / 1,000,00
Example
Required bandwith = ((Redo rate bytes per sec./0.7)*8) / 1,000,000
Required bandwith = 8.66 Mbps
