SGA Resizing Operations

SGA Resizing Operations

set linesize 140
break on timed_at skip 1
col oper_type format a14
col component format a24
col parameter format a21
col init_size heading 'Initial (MB)' format '999,999'
col fin_size  heading 'Final (MB)' format '999,999'
col change    heading 'Change (MB)' format '999,999'
select
        to_char(start_time,'dd-Mon hh24:mi:ss') timed_at,
        oper_type,
        component,
        parameter,
        oper_mode,
        initial_size/1024/1024 init_size,
        final_size/1024/1024 fin_size,
        (final_size-initial_size)/1024/1024 change
from
        v$sga_resize_ops
where
        start_time >= trunc(sysdate-14)
order by
        start_time, component
/