4.325 DBA_HIST_ENQUEUE_STAT
DBA_HIST_ENQUEUE_STAT
displays historical statistics on the number of enqueue (lock) requests for each type of lock.
This view contains snapshots of V$ENQUEUE_STATISTICS
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Type of enqueue requested |
|
|
|
Reason for the enqueue request |
|
|
|
Total number of enqueue requests or enqueue conversions for this type of enqueue |
|
|
|
Total number of times an enqueue request or conversion resulted in a wait |
|
|
|
Number of times an enqueue request or conversion was granted |
|
|
|
Number of times an enqueue request or conversion failed |
|
|
|
Total amount of time (in milliseconds) spent waiting for the enqueue or enqueue conversion |
|
|
|
Event number |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: