Oracle Technology‎ > ‎Database‎ > ‎database notes‎ > ‎

Memory Resizing

posted 21 May 2014, 04:15 by Alan Nolan-Davies
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; 
Comments