check_capture.sql

COLUMN CAPTURE_NAME HEADING 'Capture|Name' FORMAT A16
COLUMN PROCESS_NAME HEADING 'Capture|Process|Number' FORMAT A7
COLUMN SID HEADING 'Session|ID' FORMAT 9999
COLUMN SERIAL# HEADING 'Session|Serial|Number' FORMAT 9999
COLUMN STATE HEADING 'State' FORMAT A27
COLUMN TOTAL_MESSAGES_CAPTURED HEADING 'Redo|Entries|Scanned' FORMAT 9999999
COLUMN TOTAL_MESSAGES_ENQUEUED HEADING 'Total|LCRs|Enqueued' FORMAT 999999
COLUMN CAPTURE_MESSAGE_NUMBER HEADING Captured
COLUMN ENQUEUE_MESSAGE_NUMBER HEADING enqueue
COLUMN AVAILABLE_MESSAGE_NUMBER HEADING avialable

SELECT c.CAPTURE_NAME,
       SUBSTR(s.PROGRAM,INSTR(S.PROGRAM,'(')+1,4) PROCESS_NAME, 
       c.SID,
       c.SERIAL#, 
       c.STATE,
       c.TOTAL_MESSAGES_CAPTURED,
       c.TOTAL_MESSAGES_ENQUEUED ,
       c.CAPTURE_MESSAGE_NUMBER,
       c.ENQUEUE_MESSAGE_NUMBER,
       c.AVAILABLE_MESSAGE_NUMBER
  FROM V$STREAMS_CAPTURE c, V$SESSION s
  WHERE c.SID = s.SID AND
        c.SERIAL# = s.SERIAL#
/