GV$MEMORY_RESIZE_OPS definition in Oracle Database 11.2
GV$MEMORY_RESIZE_OPS

select
  op.inst_id,                              -- INST_ID NUMBER
  gv.component,                            -- COMPONENT VARCHAR2(64)
  decode(                                  -- OPER_TYPE VARCHAR2(13)
    op.opcode, 0, 'STATIC', 1, 'INITIALIZING', 2, 'DISABLED', 3, 'GROW', 4, 'SHRINK', 5, 'SHRINK_CANCEL', NULL),
  decode(                                  -- OPER_MODE VARCHAR2(9)
    op.opmode, 1, 'MANUAL', 2, 'DEFERRED', 3, 'IMMEDIATE', NULL),
  pn.name,                                 -- PARAMETER VARCHAR2(80)
  op.initsize * gv.gransize,               -- INITIAL_SIZE NUMBER
  op.targsize * gv.gransize,               -- TARGET_SIZE NUMBER
  op.realsize * gv.gransize,               -- FINAL_SIZE NUMBER
  decode(                                  -- STATUS VARCHAR2(9)
    op.status, 0, 'INACTIVE', 1, 'PENDING', 2, 'COMPLETE', 3, 'CANCELLED', 4, 'ERROR', 5, 'ERROR', 6, 'CANCELLED', 7, 'CANCELLED', NULL),
  op.starttime,                            -- START_TIME DATE
  op.endtime                               -- END_TIME DATE
from
  x$kmgsop op,
  x$kmgsct gv,
  v$parameter pn
where
  (op.grantype = gv.grantype) and (op.parno = pn.num)
order by
  op.starttime

home |  up