select
  st.inst_id,                              -- INST_ID NUMBER
  st.component,                            -- COMPONENT VARCHAR2(64)
  st.cursize * st.gransize,                -- CURRENT_SIZE NUMBER
  st.minsize * st.gransize,                -- MIN_SIZE NUMBER
  st.maxsize * st.gransize,                -- MAX_SIZE NUMBER
  st.usersize * st.gransize,               -- USER_SPECIFIED_SIZE NUMBER
  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
where
  (st.component != 'SGA Target') and (st.component != 'PGA Target')