Reduce SGA size

[sambavan]

SQL> select ksmchcom contents, count(*) chunks,
  2  sum(decode(ksmchcls, 'recr', ksmchsiz)) recreatable,
  3  sum(decode(ksmchcls, 'freeabl', ksmchsiz)) freeable,
  4  sum(ksmchsiz) total
  5  from x$ksmsp
  6  where ksmchcls not like 'R%'
  7  group by ksmchcom;

Sam