V$WAITCLASSMETRIC displays metric values of wait classes for the most recent 60-second interval. V$WAITCLASSMETRIC_HISTORY can be queried for the historical values and and a history of the last one hour will be kept in the system. Automatic Workload Repository (AWR) uses these views extensively.

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 Wait class number.
WAIT_CLASS_ID NUMBER Wait class identifier.
DBTIME_IN_WAIT NUMBER Database time spent in the wait.
TIME_WAITED NUMBER Time waited during the interval.
WAIT_COUNT NUMBER Number of times waited.