DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-04030 out of process memory

  1. #1
    Join Date
    Jun 2006
    Posts
    101

    ora-04030 out of process memory

    Hi,
    we are having problem with this big report it seems that the report is using huge amout of memory we have doubles the amount of pga_aggregate_target to 239mb still getting this error. is there anyway to calculate the value for pga_aggregate_target for this particular session or sql statment?
    or figure out how much of it its using ?

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    have you set your WORKAREA_SIZE_POLICY to AUTO?
    ---------------

  3. #3
    Join Date
    Jun 2006
    Posts
    101
    yep

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    select sid,name,value
    from v$statname n,v$sesstat s
    where n.STATISTIC# = s.STATISTIC# and name like 'session%memory%'order by 3 asc;
    ---------------

  5. #5
    Join Date
    Jun 2006
    Posts
    101
    we ran the report one more time and monitored the sga usage through TOAD the report is requiring more than 1GB of SGA_AGGRe... , we decided to break the report down.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Let me just add my two-cents...

    Fact: Your process is exhausting O/S Process Memory.

    Is it Unix/Linux?... it could be ulimit related

    Are you resorting to Bulk Collect, it worked on 9i and it's failing on 10g? If this is the case you have bumped into the same bug we bumped a couple of month ago. Solution: Remove Bulk Collect.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Jun 2006
    Posts
    101
    there is a limit on amount of memory a single process can consume on the box, we dont want to increase that limit to 1.7gb yet, we think there is a problem with the way sql statment has been writen,

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