select "INST_ID","STREAMS_NAME","STREAMS_TYPE","XIDUSN","XIDSLT","XIDSQN","CUMULATIVE_MESSAGE_COUNT","TOTAL_MESSAGE_COUNT","FIRST_MESSAGE_TIME","FIRST_MESSAGE_NUMBER","LAST_MESSAGE_TIME","LAST_MESSAGE_NUMBER","FIRST_MESSAGE_POSITION","LAST_MESSAGE_POSITION","TRANSACTION_ID","PURPOSE","CON_ID" from gv$streams_transaction
SELECT "INST_ID"
, "STREAMS_NAME"
, "STREAMS_TYPE"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "CUMULATIVE_MESSAGE_COUNT"
, "TOTAL_MESSAGE_COUNT"
, "FIRST_MESSAGE_TIME"
, "FIRST_MESSAGE_NUMBER"
, "LAST_MESSAGE_TIME"
, "LAST_MESSAGE_NUMBER"
, "FIRST_MESSAGE_POSITION"
, "LAST_MESSAGE_POSITION"
, "TRANSACTION_ID"
, "PURPOSE"
, "CON_ID"
FROM GV$STREAMS_TRANSACTION
|
|
|