Re: Malloc errors in stored procedure
Date: Sat, 13 Aug 1994 10:21:54 GMT
Message-ID: <CuGy4J.F01_at_nl.oracle.com>
Raghu=Ram%Supplier%IM=Hou_at_bangate.compaq.com (Raghu Ram) writes:
: We are experiencing the following errors quite INCONSISTENTLY. Any pointers
: to help in troubleshooting or having a workaround would be appreciated.
:
: ERROR:
: ORA-04030: out of process memory when trying to allocate 32428 bytes (pga
: heap,ksm stack)
: ORA-07324: smpall: malloc error while allocating pga.
: AT&T System V/386 Error: 12: Not enough space
:
Looks like an OS problem to me.
The underlying problem is 'AT&T System V/386 Error: 12: Not enough space'.
Oracle is asking for memory to add allocate to the PGA to accomodate the
size of the cursor, and the OS is not giving Oracle the memory. Most like
not enough swap space and/or physical memory on the machine.
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Sat Aug 13 1994 - 12:21:54 CEST