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 ?
Printable View
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.