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; |