sqloracle-databaseoracle-golden-gate

How to check Golden Gate Lag or Syncing status?

I'm trying below query to get the result but is there any other way possible to get real time golden gate syncing status?

SELECT delgroup,
     EXTRACT (DAY FROM SYSTIMESTAMP - update_timestamp) * 24 * 3600
   + EXTRACT (HOUR FROM SYSTIMESTAMP - update_timestamp) * 3600
   + EXTRACT (MINUTE FROM SYSTIMESTAMP - update_timestamp) * 60
   + EXTRACT (SECOND FROM SYSTIMESTAMP - source_commit)
      lag_update,totallag

FROM GG_LOAD.GGS_HEARTBEAT

Solution

  • Below query will give the lag status.

    SELECT delgroup,
     EXTRACT (DAY FROM SYSTIMESTAMP - update_timestamp) * 24 * 3600
   + EXTRACT (HOUR FROM SYSTIMESTAMP - update_timestamp) * 3600
   + EXTRACT (MINUTE FROM SYSTIMESTAMP - update_timestamp) * 60
   + EXTRACT (SECOND FROM SYSTIMESTAMP - source_commit)
      lag_update,totallag