Database Administration (MOSC)

MOSC Banner

Concurrency

edited Feb 2, 2024 3:36PM in Database Administration (MOSC) 15 commentsAnswered

Dear Experts,

Can we say atleast approximately, how many concurrent connections does the below configuration support?

We have 2 node RAC 19.17 version. We have single CDB with single PDB.

DB1 256 GB RAM, 4 CORE hyperthreading enabled

DB2 256 GB RAM, 4 CORE hyperthreading enabled

SGA 25GB

PGA 5GB

We planned to increase SGA to 60GB and PGA to 30GB.

In general,we will have 450 sessions connected to each node. Yesterday, we have performance issue.We have observed 1200 sessions connected to each node.

Users keep on dumping multiple custom applications into this database. We have to tell them how many max connections does this configuration 2 node RAC can support. Any help please from your expertise to get some idea.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center