分析共享池脚本 参考《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是今后可以释放的空间