GV$PROCESS_MEMORY

select
inst_id,                 -- INST_ID NUMBER
ksmpgst_pid,             -- PID NUMBER
ksmpgst_ser,             -- SERIAL# NUMBER
ksmpgst_catname,         -- CATEGORY VARCHAR2(15)
ksmpgst_alloc,           -- ALLOCATED NUMBER
decode                   -- USED NUMBER
  (ksmpgst_used, 0, to_number (null), 1, 0, ksmpgst_used),
decode                   -- MAX_ALLOCATED NUMBER
  (ksmpgst_maxal, 0, to_number (null), 1, 0, ksmpgst_maxal) 
from
x$ksmpgst 
where
bitand (ksmpgst_paflg, 1) !=0 and (ksmpgst_alloc > 0 or ksmpgst_used > 1 or ksmpgst_maxal > 1) order by inst_id,
ksmpgst_pid,
ksmpgst_catidx
home |  up  |  mailbox