GV$DISPATCHER_CONFIG

select
inst_id,                 -- INST_ID NUMBER
indx,                    -- CONF_INDX NUMBER
kmmdpnet,                -- NETWORK VARCHAR2(128)
kmmdpopt,                -- DISPATCHERS NUMBER
kmmdpcon,                -- CONNECTIONS NUMBER
kmmdpses,                -- SESSIONS NUMBER
decode                   -- POOL VARCHAR2(4)
  (bitand (kmmdpflg, 3), 0, 'OFF', 1, 'IN', 2, 'OUT', 'BOTH'),
kmmdptck,                -- TICKS NUMBER
kmmdptin,                -- INBD_TIMOUT NUMBER
kmmdptou,                -- OUTBD_TIMOUT NUMBER
decode                   -- MULTIPLEX VARCHAR2(4)
  (bitand (kmmdpflg, 12), 0, 'OFF', 4, 'IN', 8, 'OUT', 'BOTH'),
kmmdplsn,                -- LISTENER VARCHAR2(1200)
kmmdpsnm                 -- SERVICE VARCHAR2(512)
from
x$kmmdp
home |  up  |  mailbox