V$SGA_RESIZE_OPS

V$SGA_RESIZE_OPS displays information about the last 800 completed SGA resize operations. This does not include in-progress operations. All sizes are expressed in bytes.

Column Datatype Description
COMPONENT VARCHAR2(64) Component name
OPER_TYPE VARCHAR2(13) Operation type:

  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL
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
TARGET_SIZE NUMBER Requested value of the parameter after the resize
FINAL_SIZE NUMBER Real value of the parameter after the resize
STATUS VARCHAR2(9) Completion status of the operation:

  • INACTIVE

  • PENDING

  • COMPLETE

  • CANCELLED

  • ERROR
START_TIME DATE Start time of the operation
END_TIME DATE End time of the operation