分析共享池脚本

分析共享池脚本

参考《oracle性能优化实务》
SQL> col "avg size" format a30 truncate;
SQL> col siz format 999999999999
SQL> SELECT KSMCHCLS CLASS, COUNT(KSMCHCLS) NUM, SUM(KSMCHSIZ) SIZ,
  2  To_char( ((SUM(KSMCHSIZ)/COUNT(KSMCHCLS)/1024)),'999,999.00')||'k' "AVG SIZE"
  3  FROM X$KSMSP GROUP BY KSMCHCLS; 

CLASS           NUM           SIZ AVG SIZE
-------- ---------- ------------- ------------------------------
recr          11629      23151088        1.94k
freeabl        6964      18124568        2.54k
R-freea          41         13320         .32k
perm             39     254921552    6,383.25k
R-free           21       3445424      160.22k
R-perm           28      29270312    1,020.87k
free           1373       6616296        4.71k

7 rows selected.
带R的是保留池的情况
free是空闲内存 
recr是可以马上释放的
perm是不能被释放的
freeabl是今后可以释放的空间