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_MEMORY_RESIZE_OPS

DBA_HIST_MEMORY_RESIZE_OPS displays memory resize operations history. This view contains snapshots of V$MEMORY_RESIZE_OPS.

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
OPER_TYPE VARCHAR2(13) NOT NULL Operation type:
  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL

START_TIME DATE NOT NULL Start time of the operation
END_TIME DATE NOT NULL End time of the operation
TARGET_SIZE NUMBER NOT NULL Requested value of the parameter after the resize
OPER_MODE VARCHAR2(9)   Operation mode:
  • MANUAL

  • DEFERRED

  • IMMEDIATE

PARAMETER VARCHAR2(80)   Name of the parameter for the resize operation
INITIAL_SIZE NUMBER   Parameter value at the start of the operation
FINAL_SIZE NUMBER   Real value of the parameter after the resize
STATUS VARCHAR2(9)   Completion status of the operation:
  • INACTIVE

  • PENDING

  • COMPLETE

  • CANCELLED

  • ERROR