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@(protected):
> 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
--
http://www.freelists.org/webpage/oracle-l