Oracle教程 2023-02-24

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

表

Oracle 中的视图V$SERVICE_WAIT_CLASS表用来显示每个服务的等待事件的分类。它的用途是可以将每个服务的等待事件分类，从而可以为数据库观察和优化提供依据。

使用指南：

1.运行以下查询脚本，以获取视图V$SERVICE_WAIT_CLASS的信息：

SELECT service_name, wait_class_id, wait_class# FROM v$service_wait_class;

2.结果将显示每个服务的等待事件的分类信息，包括服务名称，等待类别ID和等待类别名称。

3.根据获取的信息，可以观察每个服务的等待事件分类，并协助优化数据库。

V$SERVICE_WAIT_CLASS displays aggregated wait counts and wait times for each wait statistic.

An aggregation of these wait classes is used when thresholds are imported.

Column	Datatype	Description
`SERVICE_NAME`	`VARCHAR2(64)`	Service name from `V$SERVICES`
`SERVICE_NAME_HASH`	`NUMBER`	Service name hash from `V$SERVICES`
`WAIT_CLASS_ID`	`NUMBER`	Identifier of the wait class
`WAIT_CLASS#`	`NUMBER`	Number of the wait class
`WAIT_CLASS`	`VARCHAR2(64)`	Name of the wait class
`TOTAL_WAITS`	`NUMBER`	Total number waits from this wait class by the service
`TIME_WAITED`	`NUMBER`	Total amount of time spent in waits from this wait class by the service (in hundredths of a second)
`TIME_WAITED_MICRO`	`NUMBER`	Total amount of time spent in waits from this wait class by the service (in microseconds)
`CPU`	`NUMBER`	Total amount of CPU time consumed by the service while implementing waits from this wait class (in microseconds)
`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

分享到：