分析共享池脚本

分析共享池脚本

参考《oracle性能优化实务》SQL> col "avg size" format a30 truncate;SQL> col siz format 999999999999SQL> 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.94kfreeabl        6964      18124568        2.54kR-freea          41         13320         .32kperm             39     254921552    6,383.25kR-free           21       3445424      160.22kR-perm           28      29270312    1,020.87kfree           1373       6616296        4.71k7 rows selected.带R的是保留池的情况free是空闲内存 recr是可以马上释放的perm是不能被释放的freeabl是今后可以释放的空间