GV$SHARED_SERVER
select inst_id, -- INST_ID NUMBER kmmsinam, -- NAME VARCHAR2(4) kmmsiprp, -- PADDR RAW(4) kmmsista, -- STATUS VARCHAR2(16) kmmsinmg, -- MESSAGES NUMBER kmmsinmb, -- BYTES NUMBER kmmsibrk, -- BREAKS NUMBER kmmsivcp, -- CIRCUIT RAW(4) kmmsiidl, -- IDLE NUMBER kmmsibsy, -- BUSY NUMBER kmmsitnc -- REQUESTS NUMBER from x$kmmsi where bitand (kmmsiflg, 1) !=0

home |  up  |  mailbox