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 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:
|