GV$PX_PROCESS definition in Oracle 8i / www.oracledba.ru
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 (+)