Re: Bandwidth calculation for Data Guard log shipping.

Posted by raiq1 on Mar 16, 2023; 8:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Bandwidth-calculation-for-Data-Guard-log-shipping-tp11718p11722.html

Sir,

As per your query provided by me.

select trunc(max(value)/1024*1024,1) "Max Redo MB Per Sec" from v$sysmetric_history where metric_name = 'Redo Generated Per Sec';

output is : 605960.4

after that I put above output in the formula.

Required bandwidth = ((605960.4/0.70) * 8) =  6.925 bandwidth in mbps

can you confirm me , is it a right calculation .

Regards,
Raiq