Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$FLASHBACK_TXN_GRAPH

V$FLASHBACK_TXN_GRAPH displays a tabular representation of the transaction dependency graph. For each dependency edge, there 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.

Column Datatype Description
COMPENSATING_XID RAW(8) Transaction ID of the compensating transaction
COMPENSATING_TXN_NAME VARCHAR2(255) Name of the compensating transaction
XID RAW(8) Transaction ID of a relevant transaction found in memory
TXN_NAME VARCHAR2(255) Name of the transaction with XID as the transaction ID; NULL if none
PARENT_XID RAW(8) Parent transaction ID (for a PDML transaction)
INTERESTING NUMBER If the transaction is in the transaction dependency graph
ORIGINAL NUMBER If the transaction is part of the input set provided
BACKOUT_SEQ NUMBER Order in which the transaction has been backed out
NUM_PREDS NUMBER Number of predecessors of the transaction specified by XID in the transaction graph
NUM_SUCCS NUMBER Number of successors of the transaction specified by XID in the transaction graph
DEP_XID RAW(8) One dependent transaction ID of the transaction specified by XID. This is a particular child of XID.
DEP_TXN_NAME VARCHAR2(255) Transaction name, if any, for the transaction specified by DEP_XID
TXN_CONF_SQL_ID NUMBER SQL ID of undo SQL executed in the context of XID which conflicts with the dependent transaction
DEP_TXN_CONF_SQL_ID NUMBER SQL ID of undo SQL executed in the context of DEP_XID which conflicts with XID
CONFLICT_TYPE VARCHAR2(32) The type of conflict that the conflict resolution method is used to resolve: delete, uniqueness, or update