Oracle – Linux – Network

Seberapa banyak bandwidth yang dibutuhkan untuk melakukan replikasi sebenarnya ?, sejujurnya saya juga nggak tahu, walaupun pertimbangannya adalah berapa banyak jumlah transaksi yang terjadi dalam satuan waktu tertentu.
Berikut saya melakukan percobaan kecil – kecilan dengan kondisi seperti skema ini

dari hasil test bandwidth yang sudah saya lakukan didapat angka bandwidth yang tidak pernah mencapai lebih dari 16 Kbps

Test segera dimulai
a. Pada server ORCL1, dilakukan perintah insert
SQL> insert into dept values (51,’dept’,'dept’);
SQL> insert into dept values (52,’dept’,'dept’);
………………………………………..
SQL> insert into dept values (96,’dept’,'dept’);
SQL> insert into dept values (97,’dept’,'dept’);
SQL> insert into dept values (98,’dept’,'dept’);
SQL> insert into dept values (99,’dept’,'dept’);
SQL> commit;

SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:44:40

SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
51 dept dept
52 dept dept
53 dept dept
54 dept dept
55 dept dept
56 dept dept
57 dept dept
58 dept dept
………………….
97 dept dept
98 dept dept
99 dept dept
53 rows selected.

b. Pada server ORCL2, beberapa saat kemudian [belum terjadi replikasi data]
SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:45:34

SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

c. Pada server ORCL2, dulangi langkah diatas [sudah terjadi replikasi data]
SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:45:36

SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
51 dept dept
52 dept dept
53 dept dept
54 dept dept
55 dept dept
56 dept dept
57 dept dept
58 dept dept
………………….
97 dept dept
98 dept dept
99 dept dept
53 rows selected.

jadi [Sat 29-Aug-2009 14:24:40] – [Sat 29-Aug-2009 14:25:36] = 56 detik
jadi 53 rows – 4 rows = 49 rows

d. Pada server ORCL1, dilakukan perintah delete
SQL> delete dept where deptno > 40;
49 rows deleted.
SQL> commit;
Commit complete.
SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:34:17
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

e. Pada server ORCL2, beberapa saat kemudian
SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:34:35

SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
51 dept dept
52 dept dept
53 dept dept
54 dept dept
55 dept dept
56 dept dept
57 dept dept
58 dept dept
………………….
97 dept dept
98 dept dept
99 dept dept
53 rows selected.

f. Pada server ORCL2, dulangi langkah diatas
SQL> select to_char(sysdate, ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Time” from dual;
Time
————————
Sat 29-Aug-2009 14:34:36
SQL> select * from dept order by deptno;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

jadi [Sat 29-Aug-2009 14:34:17] – [Sat 29-Aug-2009 14:34:36] = 19 detik
jadi 53 rows – 4 rows = 49 rows