Name
FLASHBACK_TRANSACTION_QUERY
Synopsis
This view shows the transactions in the system available in the undo segments. You can use this information to find out details on transactions. Available only in Oracle Database 10g.
Column name |
Description |
XID |
Transaction identifier. |
START_SCN |
SCN number at the start of the transaction. |
START_TIMESTAMP |
Start time of the transaction, in TIMESTAMP format. |
COMMIT_SCN |
SCN when the transaction was committed. |
COMMIT_TIMESTAMP |
Time when the transaction was committed, in TIMESTAMP format. |
LOGON_USER |
User who performed the transaction. |
UNDO_CHANGE# |
SCN number of the undo operation. |
OPERATION |
Operation performed by the transaction (e.g., SELECT). PL/SQL blocks will show up as either DECLARE or BEGIN. |
TABLE_NAME |
Name of the table on which the operation was performed. |
TABLE_OWNER |
Owner of the table. |
ROW_ID |
Rowid of the row that was modified by this transaction. |
UNDO_SQL |
SQL that can be used to undo the transaction. |
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.