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

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: JDunn@xxxxxxxxx
  • Date: Tue, 20 Feb 2007 21:56:52 +0100

... 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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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


Other related posts: