V$SGA_CURRENT_RESIZE_OPS

V$SGA_CURRENT_RESIZE_OPS displays information about SGA resize operations which are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component. 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 Desired value of the parameter after the resize
CURRENT_SIZE NUMBER Current value of the parameter
START_TIME DATE Start time of the operation
LAST_UPDATE_TIME DATE Last time progress was made for the operation