select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  APPLY#,                                  -- APPLY# NUMBER
  APPLY_NAME,                              -- APPLY_NAME VARCHAR2(30)
  SERVER_ID,                               -- SERVER_ID NUMBER
  STATE,                                   -- STATE VARCHAR2(20)
  XIDUSN,                                  -- XIDUSN NUMBER
  XIDSLT,                                  -- XIDSLT NUMBER
  XIDSQN,                                  -- XIDSQN NUMBER
  COMMITSCN,                               -- COMMITSCN NUMBER
  DEP_XIDUSN,                              -- DEP_XIDUSN NUMBER
  DEP_XIDSLT,                              -- DEP_XIDSLT NUMBER
  DEP_XIDSQN,                              -- DEP_XIDSQN NUMBER
  DEP_COMMITSCN,                           -- DEP_COMMITSCN NUMBER
  MESSAGE_SEQUENCE,                        -- MESSAGE_SEQUENCE NUMBER
  TOTAL_ASSIGNED,                          -- TOTAL_ASSIGNED NUMBER
  TOTAL_ADMIN,                             -- TOTAL_ADMIN NUMBER
  TOTAL_ROLLBACKS,                         -- TOTAL_ROLLBACKS NUMBER
  TOTAL_MESSAGES_APPLIED,                  -- TOTAL_MESSAGES_APPLIED NUMBER
  APPLY_TIME,                              -- APPLY_TIME DATE
  APPLIED_MESSAGE_NUMBER,                  -- APPLIED_MESSAGE_NUMBER NUMBER
  APPLIED_MESSAGE_CREATE_TIME,             -- APPLIED_MESSAGE_CREATE_TIME DATE
  ELAPSED_DEQUEUE_TIME,                    -- ELAPSED_DEQUEUE_TIME NUMBER
  ELAPSED_APPLY_TIME,                      -- ELAPSED_APPLY_TIME NUMBER
  COMMIT_POSITION,                         -- COMMIT_POSITION RAW(64)
  DEP_COMMIT_POSITION,                     -- DEP_COMMIT_POSITION RAW(64)
  LAST_APPLY_POSITION,                     -- LAST_APPLY_POSITION RAW(64)
  TRANSACTION_ID,                          -- TRANSACTION_ID VARCHAR2(128)
  DEP_TRANSACTION_ID                       -- DEP_TRANSACTION_ID VARCHAR2(128)
from
  GV$STREAMS_APPLY_SERVER
where
  INST_ID = USERENV('Instance')