DBA Data[Home] [Help]
Skip to content

VIEW: SYS.GV_$SGA_CURRENT_RESIZE_OPS

Source

View Text - Preformatted

select "INST_ID","COMPONENT","OPER_TYPE","OPER_MODE","PARAMETER","INITIAL_SIZE","TARGET_SIZE","CURRENT_SIZE","START_TIME","LAST_UPDATE_TIME","CON_ID" from gv$sga_current_resize_ops
View Text - HTML Formatted

SELECT "INST_ID"
, "COMPONENT"
, "OPER_TYPE"
, "OPER_MODE"
, "PARAMETER"
, "INITIAL_SIZE"
, "TARGET_SIZE"
, "CURRENT_SIZE"
, "START_TIME"
, "LAST_UPDATE_TIME"
, "CON_ID"
FROM GV$SGA_CURRENT_RESIZE_OPS