-
Can anyone tell me why parallel processes running, constantly increase to sometimes 30-60 Mb when I have the sort_area_size and sort_retainer_size both set to 10Mb.
I thought that they shouldn't increase above 10Mb ?
-
It is not actual sort area for a process. For some reason OS uncludes part of SGA area in a process memory. You can sum up all the processes memory on a box and the result will be greater than total memory size on the box (phisical + virtual memory). Don't be afraid.
Sergey.
-
if the query doesnt sort then sort area size wont be used at all, if the query is huge the PGA will be large consequently you see a process consuming high amount of memory. May be this is your case.
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
|