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