6.87 DBA_HIST_WAITSTAT
DBA_HIST_WAITSTAT
displays historical block contention statistics. This view contains snapshots of V$WAITSTAT
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Class of the block |
|
|
|
Number of waits by the OPERATION for this CLASS of block |
|
|
|
Sum of all wait times for all the waits by the OPERATION for this CLASS of block |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: