----------查询各个子池的内存分配情况
select 'shared pool(' ||
nvl(decode(to_char(ksmdsidx), '0', '0-unused', ksmdsidx), 'total') || ');' subpool,
sum(ksmsslen) bytes,
round(sum(ksmsslen) / 1048576, 2) mb
from x$ksmss
where ksmsslen > 0
group by rollup(ksmdsidx)
order by subpool asc
/
----------查看各个子池的内存剩余情况
SELECT KSMCHCLS CLASS,
COUNT (KSMCHCLS) NUM,
SUM (KSMCHSIZ) SIZ,
TO_CHAR ( ( (SUM (KSMCHSIZ) / COUNT (KSMCHCLS) / 1024)), '999,999.00')
|| 'k'
"AVG SIZE"
FROM X$KSMSP
GROUP BY KSMCHCLS;
---------查看各个子池更加详细的内存剩余情况
SELECT ksmchidx "SubPool",
'sga heap(' || ksmchidx || ',0)' sga_heap,
ksmchcom chunkcomment,
DECODE(ROUND(ksmchsiz / 1000),
0,
'0-1K',
1,
'1-2K',
2,
'2-3K',
3,
'3-4K',
4,
'4-5K',
5,
'5-6k',
6,
'6-7k',
7,
'7-8k',
8,
'8-9k',
9,
'9-10k',
'> 10K') "size",
COUNT(*),
ksmchcls status,
SUM(ksmchsiz) BYTES
FROM x$ksmsp
WHERE ksmchcom = 'free memory'
GROUP BY ksmchidx,
ksmchcls,
'sga heap(' || ksmchidx || ',0)',
ksmchcom,
ksmchcls,
DECODE(ROUND(ksmchsiz / 1000),
0,
'0-1K',
1,
'1-2K',
2,
'2-3K',
3,
'3-4K',
4,
'4-5K',
5,
'5-6k',
6,
'6-7k',
7,
'7-8k',
8,
'8-9k',
9,
'9-10k',
'> 10K') order by 1,2;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22034023/viewspace-708355/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22034023/viewspace-708355/