5.333 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 |
---|---|---|---|
|
|
|
Transaction ID of the compensating transaction |
|
|
|
A transaction that has been compensated by the compensating transaction |
|
|
|
A dependent transaction of Note: In the case of |
|
|
|
Mode in which
|
|
|
|
User who is performing the compensating transaction |
See Also: