Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-04030: out of process memory
ORA-04030: out of process memory [message #94393] Fri, 01 October 2004 01:38 Go to next message
Bharat Kumar M
Messages: 1
Registered: October 2004
Junior Member
Unable to execute st_getEventSummaryId ORA-04030: out of process memory when trying to allocate 16384 bytes (sort subheap,sort key) (DBD ERROR: OCIStmtExecute)

 

above was the error when trying to read through a large cursor using perl. How to resolve the above .
Re: ORA-04030: out of process memory [message #94456 is a reply to message #94393] Mon, 22 November 2004 20:21 Go to previous messageGo to next message
sujit
Messages: 94
Registered: April 2002
Member
Please check in metalink.oracle.com the following note:
Note:116076.1 Tackling ORA-4030 on WindowsNT
This should give you some input about how to solve this problem

another hint:
Do you got HASH_AREA_SIZE defined in initora ?
As default it's 2*SORT_AREA_SIZE.

If you do not have HASH_JOIN_ENABLED=FALSE, optimizer prefers it over NESTED LOOP or SORT-MERGE when joining tables. So hash join uses HASH_AREA_SIZE to store information from table 1 and if it's not enough, then Oracle uses TEMP-file. Then it's checking join condition values from table 2 against those stored values.

You may want to reduce/set the value of HASH_AREA_SIZE, so that your system is not out of memory.
Re: ORA-04030: out of process memory [message #94483 is a reply to message #94456] Fri, 17 December 2004 06:48 Go to previous message
rabea
Messages: 1
Registered: December 2004
Junior Member
i get an error in log files that there isnt memory
what can i do to sove this problem
best regards
Previous Topic: db2-oracle migration
Next Topic: why pro*c is faster than java
Goto Forum:
  


Current Time: Fri Mar 29 05:42:57 CDT 2024