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.
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 TOTALQ for average wait per item.
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 SAMPLED_TOTAL_CONN by the difference in NUM_SAMPLES (obtained from DBA_HIST_SHARED_SERVER_SUMMARY).