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?
Printable View
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?
Considering a 100 users and 30 demon, I would choose 150 or 200. max. make
Sam
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)
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