No of user for database

150 pts.
Oracle applications
Oracle Database
SQL Server
How many users can be connected to SQL and ORACLE from application end?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Both support thousands of users at a time.

Discuss This Question: 4  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    This is more likely going to be restricted by the available resources on the server, than by the database platform itself.
    85,430 pointsBadges:
  • Kccrosser
    There are some practical upper limits on concurrent "connections" to the database if you are using persistent connections. Older versions of Oracle (up through 8i) would encounter serious performance problems when more than around 800 "connections" existed. Note that "connections" is a nebulous thing - depending on the application, a single end user may wind up taking multiple connections. Connection pooling and a change of architecture in 9i and later generally allows for several thousand concurrent connections without problems. The databases can also be configured to have a maximum limit, of course. Assuming it isn't a configured limit, the number of concurrent users will be determined by the server resources (CPU performance, main memory, disk performance) and by the type of applications using the database. Simple OLTP with small transactions and a single database - thousands or tens of thousands of concurrent users. Complex OLTP with big transactions may run out of gas with hundreds of users. Simple OLTP with small transactions, but with multiple applications using multiple databases (or different sets of tables in the same database) may have performance issues, as this can degrade the cache hits. Weather modelling, signal processing, finite element analysis, etc. - one user might use all the resources.
    3,830 pointsBadges:
  • The Most-Watched IT Questions: May 4, 2010 - ITKE Community Blog
    [...] No of user for database, asked by Akansha and answered by MrDenny, CarlosDL and Kccrosser [...]
    0 pointsBadges:
  • 240210
    I have checked application users to connect database through a form limited to 150 users.
    240 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: