Golden Gate Capture | GV_$GOLDENGATE_CAPTURE

-- monitoring Golden Gate Capture


SELECT
    state,
    send_time,
    last_sent_message_number,
    (select  current_scn from v$database) as current_scn,
    ( select  SCN_TO_TIMESTAMP(current_scn) from v$database ) as SCN_TIME ,
    ((select  SCN_TO_TIMESTAMP(current_scn) from v$database  )-(send_time)) as SYNC_DLY
             FROM GV_$GOLDENGATE_CAPTURE ;