select
  sc.inst_id,                              -- INST_ID NUMBER
  sc.component,                            -- COMPONENT VARCHAR2(64)
  decode(                                  -- OPER_TYPE VARCHAR2(13)
    sc.opcode, 0, 'STATIC', 1, 'INITIALIZING', 2, 'DISABLED', 3, 'GROW', 4, 'SHRINK', 5, 'SHRINK_CANCEL', NULL),
  decode(                                  -- OPER_MODE VARCHAR2(9)
    sc.opmode, 1, 'MANUAL', 2, 'DEFERRED', 3, 'IMMEDIATE', NULL),
  pn.name,                                 -- PARAMETER VARCHAR2(80)
  sc.initsize * sc.gransize,               -- INITIAL_SIZE NUMBER
  sc.targsize * sc.gransize,               -- TARGET_SIZE NUMBER
  sc.cursize * sc.gransize,                -- CURRENT_SIZE NUMBER
  sc.starttime,                            -- START_TIME DATE
  sc.lasttime                              -- LAST_UPDATE_TIME DATE
from
  x$kmgsct sc,
  v$parameter pn
where
  (sc.parno = pn.num) and (sc.opcode <> 0) and (sc.starttime is not null) and (sc.component != 'SGA Target') and (sc.component != 'PGA Target')