Concurrent user connections with RAC

[satish]

Hi erman,

ENV:
Db version 19c
App version R12.2.5

2 node rac and 2 node shared application tier.

DB1 4 Core 128GB Ram

DB2 4 Core 128GB Ram

App1 4 core 128GB Ram->2 oacores,2 forms servers

App2 4 core 128GB Ram-> 2 oacores,2 forms servers

Max processes 700
Max sessions 1200

Recently, Concurrent users increased from 200 to 300 and some times 350.

Our max processes parameter is reached and we have increased to 1200 and similarly we have increased sessions to 2400.

With the above configuration,can you share your expertise,whether the system can handle 500 concurrent connections?


Thank you

[ErmanArslansOracleBlog]

Yes, it seems so.

But you need to analyze your connections using v$session and $process. You can check what type of connections are made, from what module, from what program, and why do they increased?

You need to get to know your environment, and then you can detect anomalies in this context and if necessary you can do better settings..

Keep in mind that; a process can have many sessions, and a session may or may not have a process.