From: Jerry Gitomer <jgitomer@p3.net>
Subject: Re: How many Users on Oracle
Date: 1997/10/10
Message-ID: <343DBC04.3801@p3.net>#1/1
References: <61e67n$6rn$1@news02.btx.dtag.de>
Organization: Surf Network
Reply-To: jgitomer@p3.net
Newsgroups: comp.databases.oracle.misc



Hi Chris,

The key is the amount of work that is being done, not the number
of users who are connected.  For example, I completely saturated
a four processor NT server with only eight users while running a
benchmark designed to simulate heavy data warehouse usage.  On 
the other hand I have been told that when running short transactions
against well indexed data bases with no more than two tables being
joined in any one transaction a four processor NT with Oracle can
easily handle thirty active users with excellent response time.  

Jerry
Christian Link wrote:
> 
> Hi!
> 
> How many users could be connected to ORACLE7 - Enterprise Server
> (Windows NT) at the same time?
> Is there a limit. What will happen, if more users will be connected (bad
> performance, etc.)?
> 
> The following variations might be used as database-Server:
> 
> A:
>         CPU : 1 * Pentium Pro 200
>         RAM : 256 MB
> B:
>         CPU : 2* Pentium Pro 200
>         RAM : 256 MB
> C:
>         CPU : 1 * Pentium Pro 200
>         RAM : 512 MB
> 
> D:
>         CPU : 2 * Pentium Pro 200
>         RAM : 512 MB
> 
> Thanx,
> 
> Chris