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(24)
  c.sid,                                   -- SID NUMBER
  c.serial#                                -- SERIAL# NUMBER
from
  x$kxfpdp a,
  V$PROCESS b,
  V$SESSION c
where
  bitand(kxfpdpflg, 8) != 0 and a.kxfpdpspid = b.SPID and a.kxfpdpspid = c.PROCESS(+)