Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
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
View PDF

DBA_FLASHBACK_TXN_STATE

DBA_FLASHBACK_TXN_STATE displays information about the compensating status of all transactions in the database. For each compensating transaction, there could be multiple rows, where each row provides the dependency relation between the transactions that have been compensated by the compensating transaction.

Related View

USER_FLASHBACK_TXN_STATE displays information about the compensating status of the transactions owned by the current user. This view does not display the USERNAME column.

Column Datatype NULL Description
COMPENSATING_XID RAW(8)   Transaction ID of the compensating transaction
XID RAW(8)   A transaction that has been compensated by the compensating transaction
DEPENDENT_XID RAW(8)   A dependent transaction of XID

Note: In the case of BACKOUT_MODE = CASCADE, there must be another row with XID = DEPENDENT_XID of this column.

BACKOUT_MODE VARCHAR2(16)   Mode in which XID was backed out:
  • NOCASCADE

  • NOCASCADE_FORCE

  • NONCONFLICT_ONLY

  • CASCADE

USERNAME VARCHAR2(30) NOT NULL User who is performing the compensating transaction