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