DBA Data[Home] [Help]

VIEW: SYS.GV_$LOGMNR_TRANSACTION

Source

View Text - Preformatted

select "INST_ID","SESSION_ID","XID","XIDUSN","XIDSLT","XIDSQN","PARENT_XID","PARENT_XIDUSN","PARENT_XIDSLT","PARENT_XIDSQN","START_TIME","START_SCN","CHUNK#","TOTAL_CHUNKS","REDO_THREAD","LOW_TIME","LOW_SCN","HIGH_TIME","HIGH_SCN","LCR_COUNT","SPILLED_LCR_COUNT","DFLAG","MFLAG","MFLAG2","STATE","TYPE","MINING_STATUS","QUEUE","SRC_CON_ID","CON_ID" from gv$logmnr_transaction
View Text - HTML Formatted

SELECT "INST_ID"
, "SESSION_ID"
, "XID"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "PARENT_XID"
, "PARENT_XIDUSN"
, "PARENT_XIDSLT"
, "PARENT_XIDSQN"
, "START_TIME"
, "START_SCN"
, "CHUNK#"
, "TOTAL_CHUNKS"
, "REDO_THREAD"
, "LOW_TIME"
, "LOW_SCN"
, "HIGH_TIME"
, "HIGH_SCN"
, "LCR_COUNT"
, "SPILLED_LCR_COUNT"
, "DFLAG"
, "MFLAG"
, "MFLAG2"
, "STATE"
, "TYPE"
, "MINING_STATUS"
, "QUEUE"
, "SRC_CON_ID"
, "CON_ID"
FROM GV$LOGMNR_TRANSACTION