Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate
Data loading:- create table t(c1 char(2000),c2 char(2000)); insert into t select ‘A’,’B’ from dual connect by rownum<1000000; commit; the data loading of 8 GB data took 160 sec . Now redo generation rate by 2 nodes RAC database as calculated by following example is:- SYS@EBILPD11> select thread#,sequence#,blocks*block_size/1024/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size/1024/1024/((next_time-first_time)*86400) “MB/s” from v$archived_log where ((next_time-first_time)*86400<>0) and first_time between to_date(‘2017/11/15 06:00:00’,’YYYY/MM/DD […]