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

home |  up  |  mailbox