| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
V$WAITSTAT displays block contention statistics. This table is only updated when timed statistics are enabled.
| Column | Datatype | Description |
|---|---|---|
CLASS |
VARCHAR2(18) |
Class of the block |
COUNT |
NUMBER |
Number of waits by this OPERATION for this CLASS of block |
TIME |
NUMBER |
Sum of all wait times for all the waits by this OPERATION for this CLASS of block |
