V$CON_SYSTEM_WAIT

7.142 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`	Total number of waits from this wait class
`TIME_WAITED`	`NUMBER`	Total amount of time spent in waits from this wait class (in hundredths of a second)
`TOTAL_WAITS_FG`	`NUMBER`	Total number of waits from this wait class, from foreground sessions
`TIME_WAITED_FG`	`NUMBER`	Total amount of time spent in waits from this wait class, from foreground sessions (in hundredths of a second)
`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.