ORA-4030, out of process memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-4030, out of process memory

  1. #1
    Join Date
    Oct 2000
    Posts
    10

    Unhappy

    Can anyone give advice as to the cause(s) of this error? It is occuring when the app tries to start a job. Performance for this particular app has been degrading over the last couple weeks. A check of the manual would lead you to believe that a user PGA cannot get it's allocated SORT_AREA_SIZE chunk of memory from the system. This app has worked fine in the past...a system reboot (HP-UX) was done 2 days ago...sys admin reports no changes in system config...no errors on the system or DB logs...no changes have been made to any init.ora parameters...I believe the Oracle version was upgraded about 2-3 weeks ago, from 8.0.5 to 8.0.6. Any help is greatly appreciated!!

  2. #2
    Join Date
    Oct 2000
    Posts
    10

    metalink no help

    FYI, we have been looking at MetaLink for help, but nothing so far that specifically addresses this problem.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Decrease the size of the SGA. I ran into this problem a few days ago on NT, decreasing the size of the SGA did it.

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