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

Thread: Parallel Processes

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    1

    Unhappy

    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 ?

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    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.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width