Question on PROCESSES parameter

[satish]

Hi Erman,

I am using oracle 12c database and application deployed on EBS weblogic 12.2

while I tried to access my application today, I faced an issue as "Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack".

Verified the process parameter limit which was almost near the max limit so I altered the process value and increment it to 1400 using the below alter command:

alter system set processes=1400 scope=spfile;
Now, everything is fine. But I provided the process count on a vague idea.

We are not using shared server configuration

My question is:

How do I decide the processes count. Is that based on my user count?
Do oracle have any calculation method for this or any other dependency?
Is processes/session count depends on RAM on the server?

Thank you for all the experts supporting us

[ErmanArslansOracleBlog]

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.