Oracle教程 2023-03-31

Oracle 视图 V$FAST_START_TRANSACTIONS 官方解释，作用，如何使用详细说明

Oracle视图V$FAST_START_TRANSACTIONS用来查看当前这些连接和用户使用的逻辑行程之间正在执行的事务. 该视图包含了事务ID，连接ID，用户ID，行程ID，激活时间，提交时间，回滚时间等信息。可以使用它来查看当前正在执行的事务，以及它们的执行时间状态。

使用Oracle视图V$FAST_START_TRANSACTIONS来查看逻辑行程之间正在执行的事务，可以执行以下SQL语句：

SELECT * FROM V$FAST_START_TRANSACTIONS;

V$FAST_START_TRANSACTIONS displays information about the progress of the transactions that Oracle is recovering.

This view displays only transactions recovered in parallel. Recovery progress for serial transactions is not displayed.

Column	Datatype	Description
`USN`	`NUMBER`	Undo segment number of the transaction
`SLT`	`NUMBER`	Slot within the rollback segment
`SEQ`	`NUMBER`	Incarnation number of the slot
`STATE`	`VARCHAR2(16)`	State of the transaction (may be `TO BE RECOVERED`, `RECOVERED`, or `RECOVERING`)
`UNDOBLOCKSDONE`	`NUMBER`	Number of undo blocks completed on the transaction
`UNDOBLOCKSTOTAL`	`NUMBER`	Total number of undo blocks that need recovery
`PID`	`NUMBER`	ID of the current server it has been assigned to
`CPUTIME`	`NUMBER`	Time for which recovery has progressed (in seconds)
`PARENTUSN`	`NUMBER`	Undo segment number of the parent transaction in PDML
`PARENTSLT`	`NUMBER`	Slot of the parent transaction in PDML
`PARENTSEQ`	`NUMBER`	Sequence number of the parent transaction in PDML
`XID`	`RAW(8)`	Transaction ID
`PXID`	`RAW(8)`	Parent transaction ID
`RCVSERVERS`	`NUMBER`	Number of servers used in the last recovery
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：