本站中文解释
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 of the interval |
|
|
|
End time of the interval |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
Number of the class of the wait event |
|
|
|
Identifier of the class of the wait event |
|
|
|
Average waiter count |
|
|
|
Percent of database time spent in the wait |
|
|
|
Time waited during the interval (in hundredths of a second) |
|
|
|
Number of times waited |
|
|
|
Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions |
|
|
|
Number of times foreground processes waited |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
