Re: Question on PROCESSES parameter
Posted by ErmanArslansOracleBlog on Feb 14, 2019; 12:49pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Question-on-PROCESSES-parameter-tp7232p7234.html
How do I decide the processes count. Is that based on my user count?
--You will analyze your env. You need to check the process and session counts in peak times.
# A database process can be associated with one or more database
# sessions. For all technology stack components other than Oracle
# Forms, there is a one-to-one mapping between sessions and processes.
#
# For Forms processes, there will be one database session per
# open form, with a minimum of two sessions per Forms user (one
# for the navigator form, and one for the active form).
Do oracle have any calculation method for this or any other dependency?
-- Please read IF:How to determine an optimum value for PROCESSES parameter (Doc ID 2012693.1)
Is processes/session count depends on RAM on the server?
--İndirectly yes.