Re: Setting up Oracle DB to be a MTS.

Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message news:38720785.B13F2AE7_at_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.

IMO, your ratio 60 seems too high.
However, it's the rule of experience, someone says 10, 20, or 25.

<Quoted from Oracle8i Tuning>

Typical systems seem to stabilize at a ratio of 1 shared server for every 10 connections.

For OLTP applications, the connections-to-servers ratio could be higher since the rate of requests could be low and the ratio of server usage-to-requests is low. In applications where the rate of requests is high or the server usage-to-request ratio is high, the connections-to-servers ratio could be lower.

In this case, set MTS_MAX_SERVERS to a reasonable value based on your application. The default value of MTS_MAX_SERVERS is 20 and the default for MTS_SERVERS is 1.

On NT, exercise care when setting MTS_MAX_SERVERS to too a high value because as mentioned, each server is a thread in a common process. The optimal values for these settings can change based on your configuration; these are just estimates of what seems to work for typical configurations.

<End Quote>

It's not a good idea for 1200 users on NT platform. Received on Wed Jan 05 2000 - 09:15:10 CST