4.322 DBA_HIST_DISPATCHER
DBA_HIST_DISPATCHER
displays historical information for each dispatcher process present at the time of the snapshot.
This view contains snapshots of information from V$DISPATCHER
and V$QUEUE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Name of the dispatcher process |
|
|
|
Serial number of the dispatcher process |
|
|
|
Total idle time for the dispatcher (in hundredths of a second) |
|
|
|
Total busy time for the dispatcher (in hundredths of a second) |
|
|
|
Total time that all items in the dispatcher queue have waited (in hundredths of a second). Divide by |
|
|
|
Total number of items that have ever been in the dispatcher queue |
|
|
|
Cumulative sum of total number of connections to the dispatcher over all samples. To determine the average number of connections to the dispatcher between two snapshots, divide the difference in |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also:
-
"V$QUEUE"