Oracle教程 2023-02-24

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

V$FAST_START_SERVERS视图用于显示Oracle数据库中使用fast_start_mttr_target（FAFST_STARTBG_MTTR_TARGET、LOCAL_MTTR_TARGET）参数设置的Mttr服务器的快速启动状态信息。

可以使用V$FAST_START_SERVERS视图获取进程的ID、服务器类型、PID、Mttr时间目标和启动状态等信息。它可以用于监视服务器的启动状态以及监测系统的性能。

V$FAST_START_SERVERS provides information about all the recovery slaves performing parallel transaction recovery.

Column	Datatype	Description
`STATE`	`VARCHAR2(11)`	State of the server (`IDLE` or `RECOVERING`)
`UNDOBLOCKSDONE`	`NUMBER`	Number of undo blocks done so far
`PID`	`NUMBER`	Process ID
`XID`	`RAW(8)`	Transaction ID
`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

分享到：