 Oracle Maximum Number of Concurrent Users [message #192054] |
Sun, 10 September 2006 10:57  |
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 #193415 is a reply to message #192054] |
Sat, 16 September 2006 07:49  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
