Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!

I think you should check your DBA_JOBS_RUNNING view if you don't have a neverending push job. 5 seconds seems to me far too small. You should push let's say every 10 minutes, if everything is well propagated and the job stops, try reducing it until it does not stop. Then use a value which allow the push to be handled in the interval with some margin for peak load times ahead. Elsewhere you will have the worse trouble to handle your replicated environments. Try to make a DB upgrade with 100000+ transactions in queue and you will meet a very long service interruption before it can proceed !

On 22 Nov 2002 07:21:27 -0800, jamie.tinker_at_transcore.com (Jamie) wrote:

>I am attempting to set up a replicated environment in Oracle 9i. I
>have all the replication set up properly (I think), yet when I make an
>update to a replicated table, the update doesn't automatically
>propagate. I can see the transaction in the replication
>administration deferred queue, and if I manually push the transaction
>it works, but it doesn't automatically send the transaction across. I
>have a schedule set up to push every 5 seconds (sysdate + 5/(60*60*24)
>). I don't know what is going on. Why won't it use the schedule to
>push the transactions? Has anyone ran into this problem??
>
>Any ideas would be GREATLY appreciated.
>
>Thanks,
>Jamie Tinker
Received on Wed Jan 15 2003 - 10:52:19 CST