V$SESSION_WAIT_CLASS

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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data