FLASHBACK_TRANSACTION_QUERY

Oracle 11gR1

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

Column	Datatype	NULL	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(30)		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(32)		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

Note:

1.

select xid, start_scn, commit_scn, logon_user, undo_change#, operation, table_name, undo_sql

from flashback_transaction_query;

XID	START_ SCN	COMMIT_ SCN	LOGON_ USER	UNDO_ CHANGE#	OPERATION	TABLE_ NAME	UNDO_SQL
000100190020C9D2	9665325364184		USERA	1	BEGIN
000100540020C9D2	9665325364173	9665325364174	SDE	1	DELETE	TABLE_LOCKS	insert into "SDE"."TABLE_LOCKS"("SDE_ID","REGISTRATION_ID","LOCK_TYPE") values ('7353111','236','S');
000100540020C9D2	9665325364173	9665325364174	SDE	2	BEGIN
000100480020C9D2	9665325364169	9665325364172	SDE	1	INSERT	PROCESS_INFORMATION	delete from "SDE"."PROCESS_INFORMATION" where ROWID = 'AAAOS9ACNAAAAxJAAl';
000100480020C9D2	9665325364169	9665325364172	SDE	2	BEGIN
000100600020C9D0	9665325364167	9665325364169	SYS	1	INSERT	DBMS_LOCK_ALLOCATED	delete from "SYS"."DBMS_LOCK_ALLOCATED" where ROWID = 'AAECevAABAAAYTRABx';
000100600020C9D0	9665325364167	9665325364169	SYS	2	BEGIN
000100520020C9CF	9665325364158	9665325364160	APP_I	1	BEGIN
0001002B0020C9D3	9665325364150	9665325364151	SYS	1	INSERT	AUD$	delete from "SYS"."AUD$" where ROWID = 'AAZ7e1ACCAAAKYjAA5';

Oracle data dictionary views