Re: Max Concurrent users on Solaris

Kent Van Meter wrote:
>
> We are anticipating several hundred concurrent users against a sparc1000
> Solaris server running 7.1, from various front ends (powerbuilder, jam,
> access, etc.) using sql*net v.1 and v.2, and odbc. Memory is 128m, the
> SGA is around 12m right now. The databases are not large, avg. 100m, but
> will get a lot of use, updating and querying. Is anyone aware of possible
> pitfalls, or will the Oracle handle the concurrent usage?
>
> TIA
>
> Kent V.Kent,

A 12mb SGA for several hundred users? Not nearly enough. One of my customers is currently running Oracle7 7.2 with a 125MB SGA for approximately 100 concurrent users and is experiencing good response times, but still experiences some minor shared pool and latch contention.

You'll definitely need to add some memory to the box.

-- 
Rich Woods, Field Support Analyst 
Oracle Corporation, USA
The comments and opinions expressed herein are mine and 
do not necessarily represent those of Oracle Corporation.