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

... 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