[ORACLE] oracle shared pool size얼마나 남았나?

출처 : http://blog.empas.com/jjh7266/read.html?a=4144437&c=376971

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;