VIEW: SYS.USER_FLASHBACK_TXN_STATE

Source

View Text - Preformatted

SELECT COMPENSATING_XID,
         XID,
         DEPENDENT_XID,
         decode(BACKOUT_MODE,
                1, 'NOCASCADE',
                2, 'NOCASCADE_FORCE',
                3, 'NONCONFLICT_ONLY',
                4, 'CASCADE') AS BACKOUT_MODE
    FROM TRANSACTION_BACKOUT_STATE$
    WHERE USER# = USERENV('SCHEMAID')

View Text - HTML Formatted

SELECT COMPENSATING_XID
, XID
, DEPENDENT_XID
, DECODE(BACKOUT_MODE
, 1
, 'NOCASCADE'
, 2
, 'NOCASCADE_FORCE'
, 3
, 'NONCONFLICT_ONLY'
, 4
, 'CASCADE') AS BACKOUT_MODE
FROM TRANSACTION_BACKOUT_STATE$
WHERE USER# = USERENV('SCHEMAID')