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

From: Nancy McCormick <nmccormick_at_sbti.com>
Date: Wed, 10 Jan 2001 08:57:22 -0500
Message-Id: <10737.126260@fatcity.com>

A snapshot refresh is either complete or fast. The complete refresh takes all the data from the master table. The fast refresh uses information stored in the master table's snapshot log (on the master site) to determine what needs to be refreshed in the snapshot. So I would try looking in the snapshot log if you are doing fast refreshes. If you are using updateable snapshots and want to see what is waiting to be pushed back to the master site, this information is stored in the def$ tables on the snapshot site.

Nancy

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of ramakrishna.gv_at_db.com
Sent: Tuesday, January 09, 2001 2:35 AM
To: Multiple recipients of list ORACLE-L Subject: Re: How to query for pending deferred transactions at MASTER site?

Hi Mohan
check in the deftrandest view;

Thanks & Regards

Ram
Tel:4236953

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

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:

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).

--

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

Author:
INET: ramakrishna.gv_at_db.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