Oracle 视图 DBA_HIST_DISPATCHER 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_DISPATCHER用于显示我们一个在instance相关任务正在运行或者已经结束。这个视图包含如下六个列：start_time，DISPATCHER_TYPE，task_id，inst_ID，task_name，status。其中start_time列指示相关任务开始时间；DISPATCHER_TYPE指示任务类型；task_id表明相关任务 ID；inst_ID显示任务所属实例；task_name显示任务名称；status 显示相关任务的状态。
要使用该视图，可以使用如下语句：
例如：
SELECT * FROM DBA_HIST_DISPATCHER WHERE DISPATCHER_TYPE= ‘RECO’ ;
该查询将返回在DISPATCHER_TYPE列记录为RECO的任务的所有信息。
官方英文解释
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$DISPATCHER”
-
“V$QUEUE”
