GV$PROCESS_MEMORY_DETAIL_PROG

select
inst_id,                 -- INST_ID NUMBER
ksmpgdp_pid,             -- PID NUMBER
ksmpgdp_ser,             -- SERIAL# NUMBER
ksmpgdp_status           -- STATUS VARCHAR2(10)
from
x$ksmpgdp 
where
bitand (ksmpgdp_paflg, 1) !=0 order by inst_id,
ksmpgdp_pid
home |  up  |  mailbox