GV$PX_PROCESS
select a.inst_id, -- INST_ID NUMBER a.kxfpdpnam, -- SERVER_NAME VARCHAR2(4) decode -- STATUS VARCHAR2(9) (bitand (a.kxfpdpflg, 16), 0, 'IN USE', 'AVAILABLE'), b.pid, -- PID NUMBER a.kxfpdpspid, -- SPID VARCHAR2(9) c.sid, -- SID NUMBER c.serial# -- SERIAL# NUMBER from x$kxfpdp a, GV$PROCESS b, GV$SESSION c where bitand (kxfpdpflg, 8) != 0 and a.inst_id = b.inst_id and a.inst_id = c.inst_id (+) and a.kxfpdpspid = b.SPID and a.kxfpdpspid = c.PROCESS (+)

home |  up  |  mailbox