select
  pid,                                     -- PID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  category,                                -- CATEGORY VARCHAR2(15)
  allocated,                               -- ALLOCATED NUMBER
  used,                                    -- USED NUMBER
  max_allocated                            -- MAX_ALLOCATED NUMBER
from
  gv$process_memory
where
  inst_id = USERENV('Instance')