Home » Other » General » Oracle Maximum Number of Concurrent Users
icon5.gif  Oracle Maximum Number of Concurrent Users [message #192054] Sun, 10 September 2006 10:57 Go to next message
koolboarder007
Messages: 2
Registered: September 2006
Location: Tampa
Junior Member

All,

I am doing a comparison of MS Sql Server and Oracle and I cannot find the maximum number of concurrent users that Oracle can handle. Does anyone know where I can find this information? I found it for SQL Server 2005 very quickly but I cannot find this information anywhere for Oracle. Any help is greatly appreciated. Thanks.
Re: Oracle Maximum Number of Concurrent Users [message #192058 is a reply to message #192054] Sun, 10 September 2006 14:07 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I really doubt it whether there is such a number. If you'd have unlimited servers, I think the number of concurrent users would be unlimited as well..
icon14.gif  Re: Oracle Maximum Number of Concurrent Users [message #192759 is a reply to message #192054] Wed, 13 September 2006 08:28 Go to previous messageGo to next message
koolboarder007
Messages: 2
Registered: September 2006
Location: Tampa
Junior Member

Thank you for your help. It sounds like several people agree with this statement as well.
Re: Oracle Maximum Number of Concurrent Users [message #193415 is a reply to message #192054] Sat, 16 September 2006 07:49 Go to previous message
gojko
Messages: 18
Registered: September 2006
Location: London
Junior Member
koolboarder007 wrote on Sun, 10 September 2006 16:57

All,

I am doing a comparison of MS Sql Server and Oracle and I cannot find the maximum number of concurrent users that Oracle can handle. Does anyone know where I can find this information? I found it for SQL Server 2005 very quickly but I cannot find this information anywhere for Oracle. Any help is greatly appreciated. Thanks.



I don't think that there is any sort of licensing limit on the number of concurrent connections, but on 32-bit architectures the memory limit for a process will be the first bottleneck, since each session (db connection) will take up a bit of memory, depending on what they do. From my experience, 2GB of process memory will allow arround 300-400 concurrent sessions (again, that depends on what your sessions are doing).

On some windows servers you can increase the limit from 2 GB to 3 GB per process, and give oracle a bit more breathing space.

Gojko Adzic
http://www.gojko.com

Previous Topic: Comparison between Oracle 7.3, 8, 8i & 9i
Next Topic: diff. between 9.2.0.6 and 9.2.0.10
Goto Forum:
  


Current Time: Fri Dec 09 05:35:46 CST 2016

Total time taken to generate the page: 0.12982 seconds