SELECT
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  STATE,                                   -- STATE VARCHAR2(21)
  APPLY#,                                  -- APPLY# NUMBER
  APPLY_NAME,                              -- APPLY_NAME VARCHAR2(30)
  TOTAL_APPLIED,                           -- TOTAL_APPLIED NUMBER
  TOTAL_WAIT_DEPS,                         -- TOTAL_WAIT_DEPS NUMBER
  TOTAL_WAIT_COMMITS,                      -- TOTAL_WAIT_COMMITS NUMBER
  TOTAL_ADMIN,                             -- TOTAL_ADMIN NUMBER
  TOTAL_ASSIGNED,                          -- TOTAL_ASSIGNED NUMBER
  TOTAL_RECEIVED,                          -- TOTAL_RECEIVED NUMBER
  TOTAL_IGNORED,                           -- TOTAL_IGNORED NUMBER
  TOTAL_ROLLBACKS,                         -- TOTAL_ROLLBACKS NUMBER
  TOTAL_ERRORS,                            -- TOTAL_ERRORS NUMBER
  UNASSIGNED_COMPLETE_TXNS,                -- UNASSIGNED_COMPLETE_TXNS NUMBER
  AUTO_TXN_BUFFER_SIZE,                    -- AUTO_TXN_BUFFER_SIZE NUMBER
  LWM_TIME,                                -- LWM_TIME DATE
  LWM_MESSAGE_NUMBER,                      -- LWM_MESSAGE_NUMBER NUMBER
  LWM_MESSAGE_CREATE_TIME,                 -- LWM_MESSAGE_CREATE_TIME DATE
  HWM_TIME,                                -- HWM_TIME DATE
  HWM_MESSAGE_NUMBER,                      -- HWM_MESSAGE_NUMBER NUMBER
  HWM_MESSAGE_CREATE_TIME,                 -- HWM_MESSAGE_CREATE_TIME DATE
  STARTUP_TIME,                            -- STARTUP_TIME DATE
  ELAPSED_SCHEDULE_TIME,                   -- ELAPSED_SCHEDULE_TIME NUMBER
  ELAPSED_IDLE_TIME,                       -- ELAPSED_IDLE_TIME NUMBER
  LWM_POSITION,                            -- LWM_POSITION RAW(64)
  HWM_POSITION,                            -- HWM_POSITION RAW(64)
  PROCESSED_MESSAGE_NUMBER                 -- PROCESSED_MESSAGE_NUMBER NUMBER
from
  GV$STREAMS_APPLY_COORDINATOR
WHERE
  INST_ID = USERENV('Instance')