Oracle 视图 DBA_FLASHBACK_TXN_REPORT 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图DBA_FLASHBACK_TXN_REPORT (快照回滚事务报告) 是用来对特定时间点之前的指定时间段内的执行的所有事务的状态进行报告, 包括COMMIT、ROLLBACK、和会话超时取消的数据修改事务. 报告也允许您在快照持续时间内识别最近活动会话和所执行的操作.
可以使用这个视图来查询给定时间段内那些事务已经COMMIT/ROLLBACK/time-out并开启/关闭.
下面是一个示例查询来获取从给定日期到指定时间点之前的所有的已提交的事务：
SELECT *
FROM DBA_FLASHBACK_TXN_REPORT
WHERE COMMIT_TIME BETWEEN ADD_MONTHS(SYSDATE,-2) AND SYSDATE
AND STATUS=’COMMITTED’;
官方英文解释
DBA_FLASHBACK_TXN_REPORT displays information about all compensating transactions that have been committed in the database.
Each row in this view is associated with one compensating transaction.
Related View
USER_FLASHBACK_TXN_REPORT displays information about the compensating transactions owned by the current user that have been committed in the database. This view does not display the USERNAME column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Transaction responsible for backout |
|
|
|
Name of the compensating transaction |
|
|
|
|
Timestamp when the compensating transaction committed |
|
|
|
|
An XML report describing the details of the transactions backed out by the compensating transaction |
|
|
|
|
|
User who is executing the compensating transaction |
See Also:
“USER_FLASHBACK_TXN_REPORT”
