select
  STREAMS_NAME,                            -- STREAMS_NAME VARCHAR2(30)
  STREAMS_TYPE,                            -- STREAMS_TYPE VARCHAR2(10)
  XIDUSN,                                  -- XIDUSN NUMBER
  XIDSLT,                                  -- XIDSLT NUMBER
  XIDSQN,                                  -- XIDSQN NUMBER
  CUMULATIVE_MESSAGE_COUNT,                -- CUMULATIVE_MESSAGE_COUNT NUMBER
  TOTAL_MESSAGE_COUNT,                     -- TOTAL_MESSAGE_COUNT NUMBER
  FIRST_MESSAGE_TIME,                      -- FIRST_MESSAGE_TIME DATE
  FIRST_MESSAGE_NUMBER,                    -- FIRST_MESSAGE_NUMBER NUMBER
  LAST_MESSAGE_TIME,                       -- LAST_MESSAGE_TIME DATE
  LAST_MESSAGE_NUMBER,                     -- LAST_MESSAGE_NUMBER NUMBER
  FIRST_MESSAGE_POSITION,                  -- FIRST_MESSAGE_POSITION RAW(64)
  LAST_MESSAGE_POSITION,                   -- LAST_MESSAGE_POSITION RAW(64)
  TRANSACTION_ID                           -- TRANSACTION_ID VARCHAR2(128)
from
  GV$STREAMS_TRANSACTION
where
  INST_ID = USERENV('Instance')