FLASHBACK_TRANSACTION

6.186 FLASHBACK_TRANSACTION_QUERY

FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database.

The database must have at least minimal supplemental logging enabled to avoid unpredictable behavior.

Column	Datatype	Description
`XID`	`RAW(8)`	Transaction identifier
`START_SCN`	`NUMBER`	Transaction start system change number (SCN)
`START_TIMESTAMP`	`DATE`	Transaction start timestamp
`COMMIT_SCN`	`NUMBER`	Transaction commit system change number; NULL for active transactions
`COMMIT_TIMESTAMP`	`DATE`	Transaction commit timestamp; NULL for active transactions
`LOGON_USER`	`VARCHAR2(128)`	Logon user for the transaction
`UNDO_CHANGE#`	`NUMBER`	Undo system change number (`1` or higher)
`OPERATION`	`VARCHAR2(32)`	Forward-going DML operation performed by the transaction: `D` - Delete `I` - Insert `U` - Update `B` `UNKNOWN`
`TABLE_NAME`	`VARCHAR2(256)`	Name of the table to which the DML applies
`TABLE_OWNER`	`VARCHAR2(386)`	Owner of the table to which the DML applies
`ROW_ID`	`VARCHAR2(19)`	Rowid of the row that was modified by the DML
`UNDO_SQL`	`VARCHAR2(4000)`	SQL to undo the DML indicated by `OPERATION`