04-06-07, 20:03 #1Registered User
- Join Date
- Apr 2007
Unanswered: Maximum number of concurrent users that can be connected to a database
How to find the maximum number of concurrent users that can be connected to a database at any point of time ?.
1) Since, for dedicated servers, UGA is part of PGA and UGA is the only part of memory used by session logins, how to calculate what percentage of PGA could be allocated for UGA till PGA maxes out ?.
2) Also, in MTS servers, what part of Large Pool (or Shared Pool if Large Pool isn't configured) could be allocated for UGA ?.
3) Can Oracle allow concurrent connections till the value indicated by processes/sessions parameter ?.
04-06-07, 21:11 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
> Can Oracle allow concurrent connections till the value indicated by processes/sessions parameter ?.
Yes (minus number of Oracle background sessions)You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.