Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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