| ORA-04030: out of process memory [message #94393] |
Fri, 01 October 2004 01:38  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
