V$SYSTEM_WAIT_CLASS

V$SYSTEM_WAIT_CLASS displays the instance-wide time totals for each registered wait class.

Column Datatype Description
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 Number of times waits of the class occurred
TIME_WAITED NUMBER Amount of time spent in the wait by all sessions in the instance
TOTAL_WAITS_FG NUMBER Number of times waits of the class occurred, in the foreground session
TIME_WAITED_FG NUMBER Amount of time spent in the wait, in the foreground session