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

COMPENSATING_XID

RAW(8)

NOT NULL

Transaction responsible for backout

COMPENSATING_TXN_NAME

VARCHAR2(256)

Name of the compensating transaction

COMMIT_TIME

DATE

Timestamp when the compensating transaction committed

XID_REPORT

CLOB

An XML report describing the details of the transactions backed out by the compensating transaction

USERNAME

VARCHAR2(128)

NOT NULL

User who is executing the compensating transaction

See Also:

“USER_FLASHBACK_TXN_REPORT”


数据运维技术 » Oracle 视图 DBA_FLASHBACK_TXN_REPORT 官方解释,作用,如何使用详细说明