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

本站中文解释

Oracle视图V$WAITCLASSMETRIC查看等待事件产生的影响情况。

* WAIT_CLASS: 指出等待事件类别,包括了像“系统 I/O”、“应用程序”、“网络”等

* TOTAL_WAITS: 总等待次数

* TIME_WAITED_MICRO: 在等待上花费的时间,单位为微秒

* AVERAGE_WAIT: 等待的平均时长,单位为微秒

使用方法:
SELECT *
FROM v$Waitclassmetric;

官方英文解释

V$WAITCLASSMETRIC displays metric values of wait classes for the most recent 60-second interval. A history of the last one hour will be kept in the system.

Column Datatype Description

BEGIN_TIME

DATE

Begin time of the interval

END_TIME

DATE

End time of the interval

INTSIZE_CSEC

NUMBER

Interval size (in hundredths of a second)

WAIT_CLASS#

NUMBER

Number of the class of the wait event

WAIT_CLASS_ID

NUMBER

Identifier of the class of the wait event

AVERAGE_WAITER_COUNT

NUMBER

Average waiter count

DBTIME_IN_WAIT

NUMBER

Percent of database time spent in the wait

TIME_WAITED

NUMBER

Time waited during the interval (in hundredths of a second)

WAIT_COUNT

NUMBER

Number of times waited

TIME_WAITED_FG

NUMBER

Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions

WAIT_COUNT_FG

NUMBER

Number of times foreground processes waited

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


数据运维技术 » Oracle 视图 V$WAITCLASSMETRIC 官方解释,作用,如何使用详细说明