ORACLE/ADMIN2011. 11. 22. 23:54
반응형
oracle shared pool size얼마나 남았나?
 
select to_number(v$parameter.value) value, v$sgastat.bytes,
(v$sgastat.bytes/v$parameter.value)*100 "Percent Free"
from v$sgastat, v$parameter
where v$sgastat.name = 'free memory'
and v$parameter.name = 'shared_pool_size';

=============================================================
DB shared pool flush시키는 명령어
alter system flush shared_pool;

반응형
Posted by [PineTree]