VIEW: SYS.INT$DBA_HIST_DISPATCHER

Source

View Text - Preformatted

select
  sn.snap_id, sn.dbid, sn.instance_number,
  d.name, d.serial#, d.idle, d.busy, d.wait, d.totalq, d.sampled_total_conn,
  decode(d.con_dbid, 0, d.dbid, d.con_dbid),
  0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_DISPATCHER d
where     sn.snap_id         = d.snap_id
      and sn.dbid            = d.dbid
      and sn.instance_number = d.instance_number

View Text - HTML Formatted

SELECT SN.SNAP_ID
, SN.DBID
, SN.INSTANCE_NUMBER
, D.NAME
, D.SERIAL#
, D.IDLE
, D.BUSY
, D.WAIT
, D.TOTALQ
, D.SAMPLED_TOTAL_CONN
, DECODE(D.CON_DBID
, 0
, D.DBID
, D.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_DISPATCHER D WHERE SN.SNAP_ID = D.SNAP_ID
AND SN.DBID = D.DBID
AND SN.INSTANCE_NUMBER = D.INSTANCE_NUMBER