GV$PROCESS_MEMORY_DETAIL

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(4)
ksmpgdst_parent_ds       -- PARENT_HEAP_DESCRIPTOR RAW(4)
from
x$ksmpgdst 
where
bitand (ksmpgdst_paflg, 1) !=0 and (ksmpgdst_bytes_alloc > 0) order by inst_id,
ksmpgdst_pid,
ksmpgdst_bytes_alloc
home |  up  |  mailbox