V$CON_SYSTEM_WAIT

7.141 V$CON_SYSTEM_WAIT_CLASS

V$CON_SYSTEM_WAIT_CLASS displays the time totals for each registered wait class in a container.

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 (in hundredths of a second) spent in the wait by all sessions
`TOTAL_WAITS_FG`	`NUMBER`	Number of times waits from this wait class occurred in foreground sessions
`TIME_WAITED_FG`	`NUMBER`	Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions
`CON_ID`	`NUMBER`	When queried from a non-CDB, time totals for each registered wait class in that instance are returned, and the `CON_ID` value is `0`. When queried from the root of a CDB, time totals for each registered wait class in every container is returned, and the `CON_ID` value indicates the container to which the time total belong. When queried from a PDB, time totals for each registered wait class in that PDB are returned, and the `CON_ID` value is the container ID for that PDB.