Datasource configuration R12.2

[satish]

Dear erman,

We have roughly 300 users on EBS, we have 2 oacore managed servers and 2 forms managed servers to support these users.We need your help in configuring max connections parameter in datasource.

Is Max connections parameter directly related to no:of users?
Will each user will have only single connection? OR each user will have more than one connection?
Can we configure Max connections to 300 as the number of users are 300?

Thank you

[ErmanArslansOracleBlog]

How many active database connections do you have? (in peak times)
How many active+inactive database connections do you have ?(in peak times)
Also, please send me the screenshot showing your data source configurations where I can see the max connection count configuration.

[satish]

Thanks for the update erman. I apologize for not making my question clear

Actually,this is a new implementation.For 300 users,how much value we can set for Max_connections parameter

Can u plz give me some reference

[ErmanArslansOracleBlog]

Ref Oracle Support:

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.

Every login requires a session. SESSIONS parameter determines the maximum number of concurrent users in the system.  SESSIONS derived from  (1.5 * PROCESSES) + 22 (11G and 12C) ,  (1.1 * PROCESSES) + 5 (10G)

Well.. There is no direct answer for your question.
It depends on lots of factors.
But, I would start by setting process to 500.
After this setting, I would monitor the connections using V$RESOURCE_LIMIT view .. (MAX_UTILIZATION for PROCESSES), and if necessarray I would modify the parameter according.