DBA_HIST_SERVICE_WAIT_CLASS displays the history of wait class information for services as tracked by the Workload Repository. This view contains information from V$SERVICE_WAIT_CLASS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
Unique snapshot ID | |
DBID |
NUMBER |
Database ID for the snapshot | |
INSTANCE_NUMBER |
NUMBER |
Instance number for the snapshot | |
SERVICE_NAME_HASH |
NUMBER |
Hash of the service name | |
SERVICE_NAME |
VARCHAR2(64) |
Name of the service | |
WAIT_CLASS_ID |
NUMBER |
Identifier for the class of the wait event | |
WAIT_CLASS |
VARCHAR2(64) |
Name for the class of the wait event | |
TOTAL_WAITS |
NUMBER |
Total number of waits for this event | |
TIME_WAITED |
NUMBER |
Total amount of time waited for this event (in hundredths of a second) |