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