GV$DISPATCHER definition in Oracle Database 10.2 / www.oracledba.ru
GV$DISPATCHER
select
inst_id, -- INST_ID NUMBER
kmmdinam, -- NAME VARCHAR2(4)
kmmdiadd, -- NETWORK VARCHAR2(128)
kmmdipro, -- PADDR RAW(4)
kmmdista, -- STATUS VARCHAR2(16)
decode -- ACCEPT VARCHAR2(3)
(kmmdiacc, 0, 'NO', 'YES'),
kmmdinmg, -- MESSAGES NUMBER
kmmdinmb, -- BYTES NUMBER
kmmdibrk, -- BREAKS NUMBER
kmmdinvo, -- OWNED NUMBER
kmmditnc, -- CREATED NUMBER
kmmdiidl, -- IDLE NUMBER
kmmdibsy, -- BUSY NUMBER
kmmdiler, -- LISTENER NUMBER
kmmdidci -- CONF_INDX NUMBER
from
x$kmmdi
where
kmmdiflg != 0