V$SGA_RESIZE_OPS

V$SGA_RESIZE_OPS displays information about the last 100 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(6)	Operation type: GROW SHRINK
OPER_MODE	VARCHAR2(6)	Operation mode: MANUAL AUTO
PARAMETER	VARCHAR2(64)	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(6)	Completion status of the operation: NORMAL CANCEL ERROR
START_TIME	DATE	Start time of the operation
END_TIME	DATE	End time of the operation