Please Help: Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Please Help: Urgent

  1. #1
    Join Date
    Jan 2002
    Posts
    96

    Arrow

    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

  2. #2
    Join Date
    Jun 2002
    Posts
    2

    Lightbulb

    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
  •  


Click Here to Expand Forum to Full Width