folks, found at metalink to see free of this query, when > 8400 we could flush the shared pool. SQL> SELECT KSMCHCLS CLASS, COUNT(KSMCHCLS) NUM, SUM(KSMCHSIZ) SIZ FROM X$KSMSP WHERE KSMCHSIZ > 8400 GROUP BY KSMCHCLS; 2 CLASS NUM SIZ -------- ---------- ---------- R-free 293 1053020760 R-freea 283 11540472 R-perm 9 11824008 free 13942 1762175536 freeabl 1115 25464840 perm 812 473364592 recr 11 1168544 according metalink bug. 4238390 , this could be gone by flushing shared_pool. so, what is the root cause of this case? regards ujang On 7/10/07, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote:
folks, shared pool is 4GB sga_target activated but so many ORA-4031 occured. the effect are some packages were invalidated..... i found on the trace files that so many vary requests of heap, such as kglsim heap 380097728 kglsim object batch 380097728 kggfaAllocSeg kgghteInit 1505964060 thanks b4 for your share.... -- regards ujang
-- regards ujang -- //www.freelists.org/webpage/oracle-l