DBA Data[Home] [Help]

VIEW: SYS.V_$FLASHBACK_TXN_MODS

Source

View Text - Preformatted

select "COMPENSATING_XID","COMPENSATING_TXN_NAME","XID","TXN_NAME","PARENT_XID","INTERESTING","ORIGINAL","BACKOUT_SEQ","UNDO_SQL","UNDO_SQL_SQN","UNDO_SQL_SUB_SQN","BACKOUT_SQL_ID","OPERATION","BACKEDOUT","CONFLICT_MOD","MODS_PER_LCR","CON_ID" from v$flashback_txn_mods
View Text - HTML Formatted

SELECT "COMPENSATING_XID"
, "COMPENSATING_TXN_NAME"
, "XID"
, "TXN_NAME"
, "PARENT_XID"
, "INTERESTING"
, "ORIGINAL"
, "BACKOUT_SEQ"
, "UNDO_SQL"
, "UNDO_SQL_SQN"
, "UNDO_SQL_SUB_SQN"
, "BACKOUT_SQL_ID"
, "OPERATION"
, "BACKEDOUT"
, "CONFLICT_MOD"
, "MODS_PER_LCR"
, "CON_ID"
FROM V$FLASHBACK_TXN_MODS