GV$STREAMS_TRANSACTION definition in Oracle Database 11.2
GV$STREAMS_TRANSACTION

SELECT
  inst_id,                                 -- INST_ID NUMBER
  strmname_knsttxn,                        -- STREAMS_NAME VARCHAR2(30)
  type_knsttxn,                            -- STREAMS_TYPE VARCHAR2(10)
  xidusn_knsttxn,                          -- XIDUSN NUMBER
  xidslt_knsttxn,                          -- XIDSLT NUMBER
  xidsqn_knsttxn,                          -- XIDSQN NUMBER
  msg_count_knsttxn,                       -- CUMULATIVE_MESSAGE_COUNT NUMBER
  actual_msg_count_knsttxn,                -- TOTAL_MESSAGE_COUNT NUMBER
  first_msg_time_knsttxn,                  -- FIRST_MESSAGE_TIME DATE
  first_msg_num_knsttxn,                   -- FIRST_MESSAGE_NUMBER NUMBER
  last_msg_time_knsttxn,                   -- LAST_MESSAGE_TIME DATE
  last_msg_num_knsttxn,                    -- LAST_MESSAGE_NUMBER NUMBER
  first_msg_pos_knsttxn,                   -- FIRST_MESSAGE_POSITION RAW(64)
  last_msg_pos_knsttxn,                    -- LAST_MESSAGE_POSITION RAW(64)
  nosxid_knsttxn                           -- TRANSACTION_ID VARCHAR2(128)
FROM
  x$knsttxn

home |  up