Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Unanswered: Maximum number of concurrent users that can be connected to a database

    Hi all,

    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 ?.

    Thanx

    -Gct

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •