V$SERVICE_WAIT_CLASS

V$SERVICE_WAIT_CLASS displays aggregated wait counts and wait times for each wait statistic. An aggregation of these wait classes is used when thresholds are imported.

Column	Datatype	Description
`SERVICE_NAME`	`VARCHAR2(64)`	Service name from `V$SERVICES`
`SERVICE_NAME_HASH`	`NUMBER`	Service name hash from `V$SERVICES`
`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 this client
`TIME_WAITED`	`NUMBER`	Amount of time (in hundredths of a second) spent in the class by this session