Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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:

  1. I made insert into on machine A.
  2. I checked but there was no data in machine B.
  3. 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.
  4. 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.

share|improve this question
    
I did another insert and at this moment it lasts over 9000 seconds (literally about 9200) in this Active Streams Transactions List. What should I do? –  Radek Dec 3 '12 at 22:12
    
Ok, I resolved the issue. I use sqlplus and I forgot to commit after insert into. That's why it did not replicate. –  Radek Dec 4 '12 at 8:54
    
Could you please post answer (as opposed to a comment) and accept it? Self-answers are welcome around here. –  kubanczyk Dec 4 '12 at 11:00
add comment

1 Answer

up vote 0 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.