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
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
|
|
|