select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  CAPTURE#,                                -- CAPTURE# NUMBER
  CAPTURE_NAME,                            -- CAPTURE_NAME VARCHAR2(30)
  LOGMINER_ID,                             -- LOGMINER_ID NUMBER
  STARTUP_TIME,                            -- STARTUP_TIME DATE
  STATE,                                   -- STATE VARCHAR2(551)
  TOTAL_PREFILTER_DISCARDED,               -- TOTAL_PREFILTER_DISCARDED NUMBER
  TOTAL_PREFILTER_KEPT,                    -- TOTAL_PREFILTER_KEPT NUMBER
  TOTAL_PREFILTER_EVALUATIONS,             -- TOTAL_PREFILTER_EVALUATIONS NUMBER
  TOTAL_MESSAGES_CAPTURED,                 -- TOTAL_MESSAGES_CAPTURED NUMBER
  CAPTURE_TIME,                            -- CAPTURE_TIME DATE
  CAPTURE_MESSAGE_NUMBER,                  -- CAPTURE_MESSAGE_NUMBER NUMBER
  CAPTURE_MESSAGE_CREATE_TIME,             -- CAPTURE_MESSAGE_CREATE_TIME DATE
  TOTAL_MESSAGES_CREATED,                  -- TOTAL_MESSAGES_CREATED NUMBER
  TOTAL_FULL_EVALUATIONS,                  -- TOTAL_FULL_EVALUATIONS NUMBER
  TOTAL_MESSAGES_ENQUEUED,                 -- TOTAL_MESSAGES_ENQUEUED NUMBER
  ENQUEUE_TIME,                            -- ENQUEUE_TIME DATE
  ENQUEUE_MESSAGE_NUMBER,                  -- ENQUEUE_MESSAGE_NUMBER NUMBER
  ENQUEUE_MESSAGE_CREATE_TIME,             -- ENQUEUE_MESSAGE_CREATE_TIME DATE
  AVAILABLE_MESSAGE_NUMBER,                -- AVAILABLE_MESSAGE_NUMBER NUMBER
  AVAILABLE_MESSAGE_CREATE_TIME,           -- AVAILABLE_MESSAGE_CREATE_TIME DATE
  ELAPSED_CAPTURE_TIME,                    -- ELAPSED_CAPTURE_TIME NUMBER
  ELAPSED_RULE_TIME,                       -- ELAPSED_RULE_TIME NUMBER
  ELAPSED_ENQUEUE_TIME,                    -- ELAPSED_ENQUEUE_TIME NUMBER
  ELAPSED_LCR_TIME,                        -- ELAPSED_LCR_TIME NUMBER
  ELAPSED_REDO_WAIT_TIME,                  -- ELAPSED_REDO_WAIT_TIME NUMBER
  ELAPSED_PAUSE_TIME,                      -- ELAPSED_PAUSE_TIME NUMBER
  STATE_CHANGED_TIME,                      -- STATE_CHANGED_TIME DATE
  APPLY_NAME,                              -- APPLY_NAME VARCHAR2(30)
  APPLY_DBLINK,                            -- APPLY_DBLINK VARCHAR2(128)
  APPLY_MESSAGES_SENT,                     -- APPLY_MESSAGES_SENT NUMBER
  APPLY_BYTES_SENT,                        -- APPLY_BYTES_SENT NUMBER
  OPTIMIZATION                             -- OPTIMIZATION NUMBER
from
  GV$STREAMS_CAPTURE
where
  INST_ID = USERENV('Instance')