Re: managing a large number of concurrent sessions

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Thu, 30 Sep 1999 14:51:26 GMT
Message-ID: <7svtd3$314$1@nnrp1.deja.com>

If you use straight Oracle dedicated server configuration, then ur box will croak when u have a large number of connections unless u have infinite hardware resources.

Use Oracle MTS( but I do not know how stable it is in Oracle 8.0.5, it was not in Oracle 7...is anyone using this for production installations). We have implemented a middleware app server connection pooling mechanism using servlets to reduce the number of dedicated user connections to the Oracle database.

-anil

In article <000b8d9b.97f84788_at_usw-ex0101-005.remarq.com>, Sean Leahy <s_leahy_at_yahoo.com> wrote:
>
>
> What is the best method for handling a large number of concurrent
> sessions. By large I mean 100, 200, or 300 sessions. Can I simply
> increase the value for SHARED_POOL_SIZE, or do I have to use MTS or
> some other type of connection pooling software?
>
> Thanks,
>
> Sean Leahy
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 09:51:26 CDT