子池share pool的空闲空间内存查询

from:DBA手记

select subpool, name, sum(bytes), round(sum(bytes) / 1048576, 2) mb

from (select 'shared pool(' ||
decode(to_char(ksmdsidx), '0', '0-unused', ksmdsidx) || '):' subpool,
ksmssnam name,
ksmsslen bytes
from x$ksmss
where ksmsslen > 0
and lower(ksmssnam) like lower('%free memory%'))
group by subpool, name
order by subpool asc, sum(bytes) desc
;