Solved

How to find the maximum number of concurrent users that can be connected to a database at any point of time ?.

Posted on 2007-03-29
7
3,051 Views
Last Modified: 2013-12-19
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 parameter ?.

Thanx

-RJ
0
Comment
Question by:vrrajeeb
7 Comments
 

Expert Comment

by:WPietruczuk
ID: 18821753
In the  initialization parameter file, you set the SESSIONS parameter to control this number of concurrent users. You should also consider changing your ENQUEUE_RESOURCES and TRANSACTION parameter values then.
0
 

Author Comment

by:vrrajeeb
ID: 18826137
What if the UGA isn't sufficient enough to accommodate the number of sessions specified by the SESSIONS/PROCESSES parameter ?.
0
 
LVL 3

Expert Comment

by:IanStuart
ID: 18897792
You don't really need to set the SESSION Parameter.
You just need to set the PROCESSES Parameter. Oracle sets the Sessions dynamically if not specified (Oracle does the following: Processes * 1.1 + 5)
0
 

Author Comment

by:vrrajeeb
ID: 19686072
My question is specifically with reference to the UGA memory and the concurrent sessions that Oracle can allocate at any point of time. Sessions/processes parameters just mention the upper ceiling in sessions. ie., Oracle won't allow any more sessions than the limits specified by SESSIONS/PROCESSES parameters. But that doens't mean Oracle WILL or CAN allow those many concurrent sessions either. That depends on the memory dynamically available at any given point in time. How to find that out is my question.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22243107
PAQed with no points refunded (of 50)

Computer101
EE Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Queries 15 48
passing parameters to sql script oracle 4 61
oracle- set role and grant privileges 6 38
Oracle Distributed Transaction Lock Error ORA-01591 8 52
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question