V$MEMORY_DYNAMIC_COMPONENTS definition in Oracle Database 11.2
V$MEMORY_DYNAMIC_COMPONENTS

select
  component,                               -- COMPONENT VARCHAR2(64)
  current_size,                            -- CURRENT_SIZE NUMBER
  min_size,                                -- MIN_SIZE NUMBER
  max_size,                                -- MAX_SIZE NUMBER
  user_specified_size,                     -- USER_SPECIFIED_SIZE NUMBER
  oper_count,                              -- OPER_COUNT NUMBER
  last_oper_type,                          -- LAST_OPER_TYPE VARCHAR2(13)
  last_oper_mode,                          -- LAST_OPER_MODE VARCHAR2(9)
  last_oper_time,                          -- LAST_OPER_TIME DATE
  granule_size                             -- GRANULE_SIZE NUMBER
from
  gv$memory_dynamic_components
where
  inst_id = USERENV('Instance')

home |  up