Oracle® Database Reference 11g Release 2 (11.2) E40402-08 |
|
|
PDF · Mobi · ePub |
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 |