DBA_HIST_WAITSTAT displays historical block contention statistics. This view contains snapshots of V$WAITSTAT.
| 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 | |
CLASS |
VARCHAR2(18) |
Class of the block | |
WAIT_COUNT |
NUMBER |
Number of waits by the OPERATION for this CLASS of block | |
TIME |
NUMBER |
Sum of all wait times for all the waits by the OPERATION for this CLASS of block |