Database Tuning (MOSC)

MOSC Banner

What are the Effects on performance of Oracle database when no. of sessions are active..

edited Jun 6, 2014 12:00PM in Database Tuning (MOSC) 7 commentsAnswered
 Hello everyone Thanks to all of you for Previous support

I want to know that what are/is the effect/s of the Oracle database when there are many active  connections (sessions ) are connected with same database.....

e.g. if there are 300 active connections (sessions) on same database....

some 40 to 50 sessions are  frequently using the database and update the database...

and others are active but not using or updating database very frequently......

so, in this situation of (so many sessions are active ) what are the effects on Oracle database Performance ?... and what Oracle do in this kind of situation.?

And if performance degrades in this kind of situation what is the solution to avoid performance degradation?

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