介绍
FLASHBACK_TRANSACTION_QUERY视图能够让我们查询当前数据库中的所有闪回事务查询的信息。数据库必须具有最小的补充日志，以避免不可预测的行为。
视图详情
| 字段名 | 字段类型 | 描述 | 译 | 备注 |
| XID | RAW(8) | Transaction identifier | 事务标识符 | |
| START_SCN | NUMBER | Transaction start system change number (SCN) | 事务开始时的系统变更号(SCN) | |
| START_TIMESTAMP | DATE | Transaction start timestamp | 事务开始时的时间戳(TIMESTAMP) | |
| COMMIT_SCN | NUMBER | Transaction commit system change number; NULL for active transactions | 事务提交时的系统变更号(SCN) | NULL代表事务在活动中 |
| COMMIT_TIMESTAMP | DATE | Transaction commit timestamp; NULL for active transactions | 事务提交时的时间戳(TIMESTAMP) | NULL代表事务在活动中 |
| LOGON_USER | VARCHAR2(30) | Logon user for the transaction | 执行事务的用户名 | |
| UNDO_CHANGE# | NUMBER | Undo system change number (1 or higher) | UNDO变更号,1或更高值 | |
| OPERATION | VARCHAR2(32) | Forward-going DML operation performed by the transaction: D - Delete I - Insert U - Update B UNKNOWN | 执行事务时的DML操作： D - 删除 I - 插入 U - 更新 B 未知 | |
| TABLE_NAME | VARCHAR2(256) | Name of the table to which the DML applies | DML操作的表名 | |
| TABLE_OWNER | VARCHAR2(32) | Owner of the table to which the DML applies | DML操作的表的拥有者 | |
| ROW_ID | VARCHAR2(19) | Rowid of the row that was modified by the DML | 由DML修改的行的ROWID | |
| UNDO_SQL | VARCHAR2(4000) | SQL to undo the DML indicated by OPERATION | 后续补充 |
评论区