GV$SGA_CURRENT_RESIZE_OPS

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              -- INITIAL_SIZE NUMBER
  * sc.gransize,
sc.targsize              -- TARGET_SIZE NUMBER
  * sc.gransize,
sc.cursize               -- CURRENT_SIZE NUMBER
  * sc.gransize,
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)
home |  up  |  mailbox