Re: multimaster replication

From: Anurag Varma <avoracle_at_gmail.com>
Date: 16 Aug 2006 14:05:26 -0700
Message-ID: <1155762326.388708.21840@p79g2000cwp.googlegroups.com>

mike7411_at_gmail.com wrote:
> I'm using Oracle 10g, and I'm planning to use multimaster
> replication to create a failover site. I need to create a function
> that specifies if the main site is in sync with the failover site or
> not. I was thinking that a good way to deal with this would be to
> check if the outgoing and incoming queues are empty. If so, they are
> in sync. Otherwise they are not.
>
> However I can't find a function to check queue sizes. Does anyone
> know of one?
>
> Thank you.

deftrandest is your friend. That would be the outgoing queue.

Anurag Received on Wed Aug 16 2006 - 16:05:26 CDT