Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to query for pending deferred transactions at MASTER site?

How to query for pending deferred transactions at MASTER site?

From: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
Date: Tue, 09 Jan 2001 12:19:51 +0530
Message-Id: <10735.126083@fatcity.com> 





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,
Received on Tue Jan 09 2001 - 00:49:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US