RE: ORA-4031 (10.1.0.5 on solaris)

Hi Ujang

Gee you get all the good ones to work out.  

http://jonathanlewis.wordpress.com/2006/12/04/resizing-the-sga/ has some comment about the use of SGA_TARGET
The following metalink notes may assist you in identifying if you are able to get it to work or if you need to find a suitable value for a fixed SGA

Note:396940.1, Note:62143.1, and Note:146599.1 might all help you to find the cause of this, whether it is a problem with the application or 4GB is too small. I am suspecting that it is an application design issue that you will find, probably not reusing code effectively, may not use binds effectively

HTH Cheers

Peter

-----Original Message-----
From: Ujang Jaenudin [mailto:ujang.jaenudin_at_gmail.com] Sent: Tuesday, 10 July 2007 02:08 PM
To: oracle-l_at_freelists.org
Subject: 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


--
http://www.freelists.org/webpage/oracle-l