Re: How to query for pending deferred transactions at MASTER site?

From: <ramakrishna.gv_at_db.com>
Date: Tue, 9 Jan 2001 13:04:04 +0530
Message-Id: <10735.126084@fatcity.com>

Hi Mohan
check in the deftrandest view;

Thanks & Regards

Ram
Tel:4236953

Message History ----------------------------------------

From: ramamohan.bn_at_tatainfotech.com on 09/01/2001 06:55 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: How to query for pending deferred transactions at MASTER site?

Hi,

In a master-snapshot site configuration, how do I find out the number of pending transactions at the MASTER site waiting to be applied(REFRESHED) at snapshot site?

select count(1) from deftran at master site doesn't reflect correct figure. Is there any other view for this?

BTW are these transactions at master site queued as deferred transactions at all!?

Thanks,
Mohan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ramamohan B N
INET: ramamohan.bn_at_tatainfotech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 09 2001 - 01:34:04 CST