V$MEMORY_RESIZE_OPS definition in Oracle Database 11.2

V$MEMORY_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
  final_size,                              -- FINAL_SIZE NUMBER
  status,                                  -- STATUS VARCHAR2(9)
  start_time,                              -- START_TIME DATE
  end_time                                 -- END_TIME DATE
from
  gv$memory_resize_ops
where
  inst_id = USERENV('Instance')

home | up