V$SGA_CURRENT_RESIZE_OPS definition in Oracle Database 11.2
V$SGA_CURRENT_RESIZE_OPS

select
  component,                               -- COMPONENT VARCHAR2(64)
  oper_type,                               -- OPER_TYPE VARCHAR2(13)
  oper_mode,                               -- OPER_MODE VARCHAR2(9)
  parameter,                               -- PARAMETER VARCHAR2(80)
  initial_size,                            -- INITIAL_SIZE NUMBER
  target_size,                             -- TARGET_SIZE NUMBER
  current_size,                            -- CURRENT_SIZE NUMBER
  start_time,                              -- START_TIME DATE
  last_update_time                         -- LAST_UPDATE_TIME DATE
from
  gv$sga_current_resize_ops
where
  inst_id = USERENV('Instance')

home |  up