Memory Resizing

Post date: May 21, 2014 11:15:13 AM

select START_TIME, component, oper_type, oper_mode, initial_size/1024/1024 "INITIAL", FINAL_SIZE/1024/1024 "FINAL", END_TIME 

from v$sga_resize_ops 

where component in ('DEFAULT buffer cache', 'shared pool') and status = 'COMPLETE' 

order by start_time, component;