process parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: process parameter

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Post

    Assuming that I have 30 daemons running in my database and 100 users(30 users concurent users at one time). What is the best value to set my PROCESS parameter to in my initSID.ora file?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Considering a 100 users and 30 demon, I would choose 150 or 200. max. make


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    It depend in whitch mode works Oracle server DEDICATED or SHARED
    if DEDICATED - then number of processes should be increace
    (>150)
    if SHARED - then number of processes may be decreace
    (~100)

  4. #4
    Join Date
    Aug 2001
    Posts
    111
    Be careful with memory requirements when using DEDICATED processes as well. Not only does each process use memory but so does each session within Oracle.

    Have a look at v$license to get a grip on the highwater mark for sessions within the database.

    It might be an idea to read up on listener connection pooling as well. i.e have multiple listener processes to share the load around (unless the webserver or front end connection does that already)

    Have Fun
    Performance... Push the envelope!

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