Re: 2tier 250users max?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 23 Nov 1999 08:56:44 -0000
Message-ID: <943347515.24183.1.nnrp-07.9e984b29@news.demon.co.uk>

There are some comments in the SQL*Net manuals that could be read as implying some sort of problem.

I don't have the CD with me right now, but I think there are comments about having no more than 250 possible connections per MTS server, and not having more than about 250 connections to a connection manager when using connection pooling where each connection manager runs on its own box.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Fuzzy wrote in message <3839c2ef.1934091_at_newshost.interact.net.au>...
>On Mon, 22 Nov 1999 15:56:09 -0500, "r.golds"
><r.golds_at_csdcsystems.com> wrote:
>
>>We want to expand the number of users that can connect to our 4g Oracle
>>database from 220 to 1500 concurrent. But we've been told that performance
>>will just die at 250 users, and that the only solution is to go to 3tier.
>>That is, at over 250 users, oracle's performance will die exponentially --
>>so queries that take 2 seconds with 200 users will take 2 years. That sort
>>of thing.
>>

>
>Whoever told you this doesn't have a clue.
>
Received on Tue Nov 23 1999 - 02:56:44 CST