Re: ORA-4031 (10.1.0.5 on solaris)

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_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l