Dynamic Performance (V$) Views, 180 of 238

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(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`	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