I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What happened:
- I made insert into on machine A.
- I checked but there was no data in machine B.
- I opened View Capture Statistics on machine A and my transaction was under Active Streams Transactions List (Running for more than 1 minute) and was Active For over 1000 seconds.
- I went to make some food and when I came back transaction had been eventually propagated to machine B.
So it looks like the transaction stayed in some kind of buffer for over 1000 seconds. How can I speed up this process? I am totally new in databases so please forgive me if it is a stupid question :).
Machines are just vbox instances (WinXP + Oracle 11g Enterprise).