DBA Data[Home] [Help]

VIEW: SYS.V_$SGA_RESIZE_OPS

Source

View Text - Preformatted

select "COMPONENT","OPER_TYPE","OPER_MODE","PARAMETER","INITIAL_SIZE","TARGET_SIZE","FINAL_SIZE","STATUS","START_TIME","END_TIME","CON_ID" from v$sga_resize_ops
View Text - HTML Formatted

SELECT "COMPONENT"
, "OPER_TYPE"
, "OPER_MODE"
, "PARAMETER"
, "INITIAL_SIZE"
, "TARGET_SIZE"
, "FINAL_SIZE"
, "STATUS"
, "START_TIME"
, "END_TIME"
, "CON_ID"
FROM V$SGA_RESIZE_OPS