Oracle教程 2023-02-24

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

Oracle视图V$BLOCKING_QUIESCE表示当前数据库正在进行quiesce数据库操作的会话及其信息。适用于数据库版本为12.2及其以上的Oracle数据库中。

Quiesce数据库操作让数据库保持一个特定的状态，这样就可以轻松备份，允许管理员控制对象部分资源，或对数据库和其对象、元数据状态进行分析，这些都需要Quiesce操作。

V$BLOCKING_QUIESCE表中存储着当前quiesce数据库操作的会话ID（SID）、进程ID（PID）、CF_FLAGS以及状态（STATUS）等信息。

使用V$BLOCKING_QUIESCE视图，管理员可以查看当前数据库正在进行quiesce数据库操作的会话信息：

SELECT SID, PID, CF_FLAGS, STATUS
FROM V$BLOCKING_QUIESCE;

V$BLOCKING_QUIESCE indicates if a session is blocking, or would block, a quiesce operation.

Column Datatype Description

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier
`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

SID

NUMBER

Session identifier

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

分享到：