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

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_FLASHBACK_TXN_REPORT displays information about all compensating transactions that have been committed in the database. Each row in this view is associated with one compensating transaction.

Related View

USER_FLASHBACK_TXN_REPORT displays information about the compensating transactions owned by the current user that have been committed in the database. This view does not display the USERNAME column.

Column Datatype NULL Description
COMPENSATING_XID RAW(8) NOT NULL Transaction responsible for backout
COMPENSATING_TXN_NAME VARCHAR2(256)   Name of the compensating transaction
COMMIT_TIME DATE   Timestamp when the compensating transaction committed
XID_REPORT CLOB   An XML report describing the details of the transactions backed out by the compensating transaction
USERNAME VARCHAR2(30) NOT NULL User who is executing the compensating transaction