4.265 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(128)

NOT NULL

User who is performing the compensating transaction