GV$SGA_RESIZE_OPS

select
op.inst_id,              -- INST_ID NUMBER
gv.component,            -- COMPONENT VARCHAR2(64)
decode                   -- OPER_TYPE VARCHAR2(6)
  (op.opcode, 1, 'GROW', 2, 'SHRINK', NULL),
decode                   -- OPER_MODE VARCHAR2(6)
  (op.opmode, 1, 'MANUAL', 2, 'AUTO', NULL),
pn.name,                 -- PARAMETER VARCHAR2(64)
op.initsize              -- INITIAL_SIZE NUMBER
  * gv.gransize,
op.targsize              -- TARGET_SIZE NUMBER
  * gv.gransize,
op.realsize              -- FINAL_SIZE NUMBER
  * gv.gransize,
decode                   -- STATUS VARCHAR2(6)
  (op.status, 1, 'NORMAL', 2, 'CANCEL', 3, 'ERROR', NULL),
op.starttime,            -- START_TIME DATE
op.endtime               -- END_TIME DATE
from
x$ksmgop op,
x$ksmgv gv,
v$parameter pn 
where
(op.grantype = gv.grantype) and (op.parno = pn.num) order by op.starttime
home |  up  |  mailbox