Oracle教程 2023-03-26

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

_STAT ？

Oracle视图V$QUEUEING_MTH_STAT用于收集关于每个列队实例数据的信息，准确表示被列队服务中活动数据以及可能产生的数据。通常，它用于监控或调试时，以便了解特定列队实例的当前状态。它提供了有关延迟，抢占和结果错误等统计信息，以便支持列队协调程序对于列队实例的理解。

使用V$QUEUEING_MTH_STAT在数据库中启动列队实例的正常运行可以通过调用视图显示视图信息，以查看其当前状态。可以使用以下查询来查看列队实例的状态。

SELECT *
FROM V$QUEUEING_MTH_STAT
WHERE QInst_ID = ‘Queue Instance ID’;

V$QUEUEING_MTH displays all available queuing resource allocation methods.

Column Datatype Description

Column	Datatype	Description
`NAME`	`VARCHAR2(40)`	Name of the queuing resource allocation method
`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

NAME

VARCHAR2(40)

Name of the queuing resource allocation method

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

分享到：