Estado de queue de replicacion | ExpoDBA

Estado de queue de replicacion

Estado de queue de replicacion

COLUMN GLOBAL_NAME HEADING 'Database' FORMAT A25
COLUMN ADMIN_REQUESTS HEADING 'Admin|Reqests' FORMAT 99999999
COLUMN STATUS HEADING 'Admin|Errors' FORMAT 99999999
COLUMN TRAN HEADING 'Def|Trans|Pairs' FORMAT 99999999
COLUMN ERRORS HEADING 'Def|Trans|Errors' FORMAT 99999999
COLUMN COMPLETE HEADING 'Propagated|Trans' FORMAT 9999999

SELECT G.GLOBAL_NAME, D.ADMIN_REQUESTS, E.STATUS, DT.TRAN, DE.ERRORS, C.COMPLETE
FROM (SELECT GLOBAL_NAME FROM GLOBAL_NAME) G,
(SELECT COUNT(ID) ADMIN_REQUESTS FROM DBA_REPCATLOG) D,
(SELECT COUNT(STATUS) STATUS FROM DBA_REPCATLOG WHERE STATUS = 'ERROR') E,
(SELECT COUNT(*) TRAN FROM DEFTRANDEST) DT,
(SELECT COUNT(*) ERRORS FROM DEFERROR) DE,
(SELECT COUNT(A.DEFERRED_TRAN_ID) COMPLETE FROM DEFTRAN A
WHERE A.DEFERRED_TRAN_ID NOT IN (
SELECT B.DEFERRED_TRAN_ID FROM DEFTRANDEST B)) C;