select
  pid,                                     -- PID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  category,                                -- CATEGORY VARCHAR2(15)
  name,                                    -- NAME VARCHAR2(26)
  heap_name,                               -- HEAP_NAME VARCHAR2(15)
  bytes,                                   -- BYTES NUMBER
  allocation_count,                        -- ALLOCATION_COUNT NUMBER
  heap_descriptor,                         -- HEAP_DESCRIPTOR RAW(8)
  parent_heap_descriptor                   -- PARENT_HEAP_DESCRIPTOR RAW(8)
from
  gv$process_memory_detail
where
  inst_id = USERENV('Instance')