Re: Oracle 8i Connections limit and performance

This depends on many many factors.
General guideline is to allow for 8 Mb memory per dedicated session. When you are running MTS this becomes a completely different story of course.

Hth,

Sybrand Bakker, Oracle DBA

Yoav Gelbfish <yoav_at_netune.net> wrote in message news:8au40p$n5r$1_at_cedar.ggn.net...
> Hi Everyone,
>
> I got a question which i hope here's the right place to ask it.
>
> I know the answer to this question is also machine-dependent but i'd like
to
> get some general guideline and hints regarding this question from the
users
> in this newsgroup.
>
> How many _active_ connections can the Orcale DB handle with adequate
> performance for each connection when the machine is a one CPU machine with
> more then enough ram? how does it scale when more CPUs are added?
>
> (btw, ofcourse i'm talking on a UNIX version of Oracle)
>
> Thanks
>
> Yoav Gelbfish
> yoav_at_netune.net
>
>
>
>
Received on Fri Mar 17 2000 - 16:28:02 CST