GV$PROCESS_MEMORY definition in Oracle Database 11.2
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