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