V$SGA_RESIZE

V$SGA_RESIZE_OPS

V$SGA_RESIZE_OPS displays information about the last 400 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