Re: ORA 4031

"David COSTE" <dco_at_compaq.com> writes:
> I am using oracle 9.2.0.1 under HPUX.
> I have the following error occuring very frequently :
>
> ORA-04031: unable to allocate 2216 bytes of shared memory ("shared
> pool","CVI_S1_S1_L2_7_H","KGLS heap","KGLS MEM BLOCK")
> ORA-02063: preceding line from DMPROD
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
> ORA-06512: at "SYS.DBMS_SQL", line 316
>
> dos someone know what is the KGLS heap ?

On 8.1.6 I had the same problem. I did not know how to fix it but what did prevent it from appearing was issuing command alter system flush shared pool ;
every once and while. I actually made a program that issued this command every day. Our system would run maybe one week without this and after that started giving 4031 on random statements and always when system was pretty busy.

Then, I've got no clue if this is still the same problem..

-- 
Antti Järvinen, costello_at_iki.fi
            "concerto for two faggots and orchestra"