Impact of increasing PROCESSES
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Impact of increasing PROCESSES

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    Impact of increasing PROCESSES

    Impact of Increasing PROCESSES parameter

    Hi All,
    Based on the research I find that other than slight increase in the SGA size, increasing the number of PROCESSES shouldn't need any additional changes in the memory settings such as SGA (Shared pool needs to be increase slightly?) or PGA.

    Can you please comment on the effects of increasing the PROCESSES from 800 to 1500 or 2000. SGA right now is 2GB (1GB BC,400M Shared pool + rest in all pools)

    I need to know if we need to increase the PGA aggregate target to allow for the additional processes/connections that might come in.
    There is always a better way to do the things.

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    Any comment on other memory areas that needs to be increased due to increasing the PROCESSES parameter from 800 to say 1500 or 2000.
    There is always a better way to do the things.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    whats the size of PGA? and is workarea_size_policy auto?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------
    pga_aggregate_target big integer 419430400
    workarea_size_policy string AUTO
    There is always a better way to do the things.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    if you see any ora errors related to processes not getting enough memory, then consider increasing.. btw, why dont you use sga_target?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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