Re: consolidating deferred transaction queue

From: Patrice <"patrice_castet_dba>
Date: Fri, 01 Sep 2006 09:33:58 +0200
Message-ID: <44f7e266$0$428$4d4eb98e@read.news.fr.uu.net>

> Let's say that, before the queue is ever pushed, Joe's numemailmessages
> gets set to 10, 11, 12, 13, 14, and 15. Will these ever be
> consolidated into one update? Can you configure this?

no, all transactions are pushed to remote sites, oracle does not mix transactions together. It uses 2 phase commits to make sure a transactions is pushed to the right site. If you have pb with bandwidth modify your softs in order it generates less transactions; or change the way to replicate, there is also streams, dataguard, rac, ...

Patrice Castet
sr Oracle DBA Received on Fri Sep 01 2006 - 02:33:58 CDT