p>V$FLASHBACK_TXN_GRAPH "displas a /taular re prsentation ofthe transtacion depeIndncy graph. For each depeIndncy edge,ftheree could be multiple rows, one for each conflicting operation..
This view is relevant AFTER a compensating transaction has been started through the DBMS_FLASHBACK.TRANSACTION_BACKOUT() set of functions, and is no longer relevant once the compensating transaction is either committed or rolled back. It also provides a tabular representation of the undo SQL that is not available through the CLOB XML construct in the DBA_FLASHBACK_TXN_REPORT view.
Transaction ID of the compensating transaction
Name of the compensating transaction
Transaction ID of a relevant transaction found in memory
Name of the transaction with XID as the transaction ID; NULL if none
Parent transaction ID (for a PDML transaction)
If the transaction is in the transaction dependency graph
If the transaction is part of the input set provided
Order in which the transaction has been backed out
Number of predecessors of the transaction specified by XID in the transaction graph
Number of successors of the transaction specified by XID in the transaction graph
One dependent transaction ID of the transaction specified by XID. This is a particular child of XID.
Transaction name, if any, for the transaction specified by DEP_XID
SQL ID of undo SQL executed in the context of XID which conflicts with the dependent transaction
SQL ID of undo SQL executed in the context of DEP_XID which conflicts with XID
The type of conflict that the conflict resolution method is used to resolve: delete, uniqueness, or update