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
FROM
x$knsttxn
home |  up  |  mailbox