DBA Data[Home] [Help]

VIEW: SYS.FLASHBACK_TRANSACTION_QUERY

Source

View Text - Preformatted

select xid, start_scn, start_timestamp,
          decode(commit_scn, 0, commit_scn, 281474976710655, NULL, commit_scn)
          commit_scn, commit_timestamp,
          logon_user, undo_change#, operation, table_name, table_owner,
          row_id, undo_sql
from sys.x$ktuqqry
View Text - HTML Formatted

SELECT XID
, START_SCN
, START_TIMESTAMP
, DECODE(COMMIT_SCN
, 0
, COMMIT_SCN
, 281474976710655
, NULL
, COMMIT_SCN) COMMIT_SCN
, COMMIT_TIMESTAMP
, LOGON_USER
, UNDO_CHANGE#
, OPERATION
, TABLE_NAME
, TABLE_OWNER
, ROW_ID
, UNDO_SQL FROM SYS.X$KTUQQRY