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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-04030: out of process memory when trying to allocate 5424 bytes (cursor work he,Scan compression ctx)

Re: ORA-04030: out of process memory when trying to allocate 5424 bytes (cursor work he,Scan compression ctx)

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 20 Feb 2007 21:56:52 +0100
Message-ID: <486b2b610702201256x4eef1604y966c51d30bcdfa43@mail.gmail.com>


... or increase the oracle user's ulimit, or kernel limit perhaps (you didn't mention which platform) ? What does ulimit -a tell you ?

Stefan

On 2/19/07, Powell, Mark D <mark.powell_at_eds.com> wrote:
>
> The error means pretty much that you have no more free OS memory
> available. You need to either expand the OS memory or reduce the load on
> the machine.
>
> $ oerr ora 04030
> 04030, 00000, "out of process memory when trying to allocate %s bytes
> (%s,%s)"
> // *Cause: Operating system process private memory has been exhausted
> // *Action:
>
> -- Mark D Powell --
> Phone (313) 592-5148
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *John Dunn
> *Sent:* Monday, February 19, 2007 6:05 AM
> *To:* oracle-l
> *Subject:* ORA-04030: out of process memory when trying to allocate 5424
> bytes (cursor work he,Scan compression ctx)
>
> Anyone seen this error before in Oracle 9?
>
> ORA-04030: out of process memory
> when trying to allocate 5424 bytes (cursor work he,Scan compression ctx)
>
> Cannot find anything on metalink related to Scan compression ctx)
>
>
> John
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 20 2007 - 14:56:52 CST

Original text of this message

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