V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis.

Column Datatype Description
SID NUMBER Session identifier
SERIAL# NUMBER Serial number
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 for the session
TIME_WAITED NUMBER Amount of time spent in the wait class by the session