GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Multimaster asynchronous serial/parallel replication propagation

edited Jul 4, 2014 1:13PM in GoldenGate, Streams and Distributed Database (MOSC) 9 commentsAnswered

I have oracle 10g and 2masters with  parallel propagation (PUSH ...delay_seconds=>0, parallelism=>1) configured. From time to time replication  stops (PUSH job locks some resources) and after some time DB gets unsynchronized. To start it back I do kill-9 p00x. I did not determined a reason  yet, but my support advice me to change PUSH job  to parallelism=0  (serial propagation) to avoid using p00x processes. I must also say that DB is small one.

Was this right decision? Does anybody know if there is a bug in p00x ? Or perhaps someone knows what is a most critical task in parallel propagation that can lock resources forever.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center