| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
Amount of time spent in the class by this session |
TIME_WAITED |
NUMBER |
Number of times waits of the class occurred for this client |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
