Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting up Oracle DB to be a MTS.

Re: Setting up Oracle DB to be a MTS.

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 04 Jan 2000 09:45:25 -0500
Message-ID: <38720785.B13F2AE7@Unforgettable.com>


Paul Bennett wrote:
>
> Even with MTS? What if only a 100 or so are doing something at any one time?
> How much overhead is there if 1200 people were simply connected to the machine
> and not doing anything.
>
> I agree that 1200 dedicated user processes would be insane, but what about MTS
> with only 100 dedicated?
>
> -- Paul
>
> Sybrand Bakker wrote:
>
> > In Oracle 7 it doesn't, in Oracle 8 it does. But then again, I wouldn't go
> > for 1200 users on a NT server.

The ratio of users to MTS server processes is 60:1. So if you have 100 users you'd need two server processes. With 1200 users it would be 20 server processes. Received on Tue Jan 04 2000 - 08:45:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US