GV$SGA_CURRENT_RESIZE_OPS

select
sc.inst_id,              -- INST_ID NUMBER
gv.component,            -- COMPONENT VARCHAR2(64)
decode                   -- OPER_TYPE VARCHAR2(6)
  (sc.opcode, 1, 'GROW', 2, 'SHRINK', NULL),
decode                   -- OPER_MODE VARCHAR2(6)
  (sc.opmode, 1, 'MANUAL', 2, 'AUTO', NULL),
pn.name,                 -- PARAMETER VARCHAR2(64)
sc.initsize              -- INITIAL_SIZE NUMBER
  * gv.gransize,
sc.targsize              -- TARGET_SIZE NUMBER
  * gv.gransize,
sc.realsize              -- CURRENT_SIZE NUMBER
  * gv.gransize,
sc.starttime,            -- START_TIME DATE
sc.lasttime              -- LAST_UPDATE_TIME DATE
from
x$ksmgsc sc,
x$ksmgv gv,
v$parameter pn 
where
(sc.grantype = gv.grantype) and (sc.parno = pn.num) and (sc.opcode <> 0) and (sc.starttime is not null)
home |  up  |  mailbox