Transaction stays in capture queue 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).

Greetings.
I was using sqlplus and I forgot to commit the changes. Before the commit, changes appeared only in the source database, but after I had committed them, the destination database got the new data.