Oracle FLASHBACK_TRANSACTION_QUERY

最新推荐文章于 2025-02-25 14:07:15 发布

原创最新推荐文章于 2025-02-25 14:07:15 发布 · 708 阅读

本内容遵循CC 4.0 BY-SA版权协议

收录于

本文详细介绍了Oracle数据库中Flashback Transaction Query的功能与使用方法。此特性允许用户查询所有闪回事务，包括事务标识、开始与结束SCN、时间戳、操作类型及涉及的表等信息，为数据库管理和故障排查提供了有力支持。

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

Column	Datatype	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 # (`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`