Re: ORA-04030 : (pga heap,kco buffer)

From: Andy Wattenhofer <watt0012_at_umn.edu>
Date: Wed, 30 Apr 2014 12:16:28 -0500
Message-ID: <CAFU3ey7EpVu2pgjExj1gO-B2Z4c=1ea+veksfm+aLNviKh8yuA_at_mail.gmail.com>

Go a general knowledge search . I tried searching for "qmxdGetElemsBy" and found bug 16596183<https://support.oracle.com/epmos/faces/BugDisplay?id=16596183>, which appears to be unpublished but which is patched with the 11.2.0.4.1 patch bundle.

On Wed, Apr 30, 2014 at 8:57 AM, Mohamed Houri <mohamed.houri_at_gmail.com>wrote:

> Dears,
>
>
> I have been asked to trouble shoot an ORA-04030 that occurred yesterday
> and this morning when trying to parse XML message with 3MB.
>
>
>
> ORA-04030: out of process memory when trying to allocate 824504 bytes (pga
> heap,kco buffer)
>
> ORA-04030: out of process memory when trying to allocate 4032 bytes
> (qmxdGetElemsBy,qmemNextBuf:alloc)
>
>
>
> I have tried to use the My Oracle Support ORA-04030 diagnostic tool but
> didn’t accept my trace file
>
>
>
> I have an AWR report corresponding to the period when the error occurred.
>
>
>
> What could you suggest me to do in order to find the reason of this PGA
> error and bring a solution
>
>
>
> Thanks in advance
> --
> Bien Respectueusement
> Mohamed Houri
> www.hourim.wordpress.com
>

-- 
Andy Wattenhofer
Manager, Database Administration
University of Minnesota

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

Received on Wed Apr 30 2014 - 19:16:28 CEST