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