Re: Memory for client connections

In article fsf_at_cerberus.atlassoft.com, tyson_at_cerberus.atlassoft.com (Tyson Chihaya) writes:
> >
> > Hi,
> >
> > We're trying to design a large-scale client-server system, and we're
> > anticipating a large number of concurrent connections from our oracle
> > client to our oracle server. The number of connections that we can
> > make from a Sun Ultra with 192 MB of ram to our oracle server seems
> > to be about 70.

 [snip]
> > Also, has anyone else dealt with needing to service thousands of users
> > with one oracle database? I think the final solution lies in having
> > many users on each database connection...
> >
> > thanks,
> > tyson

Tyson,

We manage several large databases. One in particular is over 200 Gb with more than 1,100 concurrent users. What is the configuration?

	Sun SparcServer 2000, 16 CPU's 5 Gb RAM
	ORACLE 7.1.6
	SGA - 900 Mb (approximately 350 Mb buffers, 300 Mb Shared Pool, ...)
	All RAW DEVICES except the system tablespace (yes the redo logs are on raw)

If you have any other questions please feel free to contact us directly. The use of two tier servers is a good idea to share the process load.

Marc

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->