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