GV$SGA_DYNAMIC_COMPONENTS
select st.inst_id, -- INST_ID NUMBER st.component, -- COMPONENT VARCHAR2(64) st.cursize -- CURRENT_SIZE NUMBER * st.gransize, st.minsize -- MIN_SIZE NUMBER * st.gransize, st.maxsize -- MAX_SIZE NUMBER * st.gransize, st.usersize -- USER_SPECIFIED_SIZE NUMBER * st.gransize, st.opercnt, -- OPER_COUNT NUMBER decode -- LAST_OPER_TYPE VARCHAR2(13) (st.lastoper, 0, 'STATIC', 1, 'INITIALIZING', 2, 'DISABLED', 3, 'GROW', 4, 'SHRINK', 5, 'SHRINK_CANCEL', NULL), decode -- LAST_OPER_MODE VARCHAR2(9) (st.lastmode, 1, 'MANUAL', 2, 'DEFERRED', 3, 'IMMEDIATE', NULL), st.lasttime, -- LAST_OPER_TIME DATE st.gransize -- GRANULE_SIZE NUMBER from x$kmgsct st

home |  up  |  mailbox