DBA_HIST_MEM_DYNAMIC_COMP

DBA_HIST_MEM_DYNAMIC_COMP displays historical memory component sizes. This view contains snapshots of V$MEMORY_DYNAMIC_COMPONENTS.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
COMPONENT VARCHAR2(64) NOT NULL Component name
CURRENT_SIZE NUMBER   Current size of the component
MIN_SIZE NUMBER   Minimum size of the component since instance startup
MAX_SIZE NUMBER   Maximum size of the component since instance startup
USER_SPECIFIED_SIZE NUMBER   Value of the user parameter for the component
OPER_COUNT NUMBER   Number of operations since instance startup
LAST_OPER_TYPE VARCHAR2(13)   Last completed operation for the component:

  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL
LAST_OPER_MODE VARCHAR2(9)   Mode of the last completed operation:

  • MANUAL

  • DEFERRED

  • IMMEDIATE
LAST_OPER_TIME DATE   Start time of the last completed operation
GRANULE_SIZE NUMBER   Granularity of the GROW or SHRINK operation