select
  inst_id,                                 -- INST_ID NUMBER
  ksmpgdst_pid,                            -- PID NUMBER
  ksmpgdst_ser,                            -- SERIAL# NUMBER
  ksmpgdst_catname,                        -- CATEGORY VARCHAR2(15)
  ksmpgdst_comment,                        -- NAME VARCHAR2(26)
  ksmpgdst_heapname,                       -- HEAP_NAME VARCHAR2(15)
  ksmpgdst_bytes_alloc,                    -- BYTES NUMBER
  ksmpgdst_num_alloc,                      -- ALLOCATION_COUNT NUMBER
  ksmpgdst_ds,                             -- HEAP_DESCRIPTOR RAW(8)
  ksmpgdst_parent_ds                       -- PARENT_HEAP_DESCRIPTOR RAW(8)
from
  x$ksmpgdst
where
  bitand(ksmpgdst_paflg,1)!=0 and (ksmpgdst_bytes_alloc > 0)
order by
  inst_id,
  ksmpgdst_pid,
  ksmpgdst_bytes_alloc