-
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 ?
-
have you set your WORKAREA_SIZE_POLICY to AUTO?
---------------
-
-
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;
---------------
-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|