select
  pid,                                     -- PID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  status                                   -- STATUS VARCHAR2(10)
from
  gv$process_memory_detail_prog
where
  inst_id = USERENV('Instance')