Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 4031

Re: ORA 4031

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 May 2003 06:08:49 -0700
Message-ID: <2687bb95.0305070508.4c25d8f3@posting.google.com>


"David COSTE" <dco_at_compaq.com> wrote in message news:<sM4ua.404$Tl1.17_at_news.cpqcorp.net>...
> Hello,
>
> 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 ?
>
> Thanks in advance
> David

David, I cannot answer your question on the KGLS heap, but I was wondering have you contacted Oracle support to see if this 04031 is caused by a known bug? Also have you reviewed the metalink 04031 documentation to make sure your shared pool is not just too small, that you need to increase the reserved area above the default, or a similar manageable condition?

HTH -- Mark D Powell -- Received on Wed May 07 2003 - 08:08:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US