GV$SGA_DYNAMIC_COMPONENTS
select st.inst_id, -- INST_ID NUMBER gv.component, -- COMPONENT VARCHAR2(64) st.cursize -- CURRENT_SIZE NUMBER * gv.gransize, st.minsize -- MIN_SIZE NUMBER * gv.gransize, st.maxsize -- MAX_SIZE NUMBER * gv.gransize, st.opercnt, -- OPER_COUNT NUMBER decode -- LAST_OPER_TYPE VARCHAR2(6) (st.lastoper, 1, 'GROW', 2, 'SHRINK', NULL), decode -- LAST_OPER_MODE VARCHAR2(6) (st.lastmode, 1, 'MANUAL', 2, 'AUTO', NULL), st.lasttime, -- LAST_OPER_TIME DATE gv.gransize -- GRANULE_SIZE NUMBER from x$ksmgst st, x$ksmgv gv where (st.grantype = gv.grantype)

home |  up  |  mailbox