-
Hi there Ghuru's i need you help urgently please.
Every 4 Days oracle 9i Kicks out this error message.
Can anybody help? HAs anybody seen this error?
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
subheap,sort key)
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
subheap,sort key)
Thanks Ghuru's
-
What version are you on. In 9.2 they've fixed a lot of those errors. They used to occur quite a bit in 8.1.x as well. With the recursive word in the error I would attribute it to maybe this bug fix:
Fixed: 8172 9011 9201
Resource Leaks (eg: Memory Leak)
PL/SQL
A memory leak of private shadow memory , or ultimately an ORA-4030,
can occur if a long running PLSQL block repeatedly binds in a loop.
But there are about 4 Bug Fixes attributable to this Oracle Error under metalink, for examle RAC has issues, and doing Hash Joins under occasions would cause issues..
Hope that helps.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|