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