Re: to MTS or not to MTS

I know nothing about Sun Solaris. I've read that if your operating system limits the number of processes that can be spawned, this may force you to use MTS.

If you have enough RAM to support 1,100 server processes in addition the other processes running on the CPU, more power to you. Just remember that those processes are sitting idle, taking up machine resources waiting for individual users to execute SQL statements. If your running a Forms front end, you're only getting a few transactions per minute in the best of data entry environments.

Best!

Randall Roberts

David Boucher <dazed_dba_at_yahoo.co.uk> wrote in message news:20010523151048.42749.qmail_at_web14407.mail.yahoo.com...
> Hi,
>
> We have an 8.1.6 db running on Solaris 2.7. We have
> approx 250 concurrent users using dedicated server
> processes and everything is fine. The Business has
> deemed it necessary to increase the number of current
> users up to around 1100. This obviously presents us
> DBA's with many interesting questions. One being, is
> there any real need to move to MTS?. We have tried
> this before we went live and we ran into the problem
> where it would randomly hang connections for a minute,
> and discovered this was an oracle bug. I forget the
> number.
>
> Getting extra Ram/CPU put in the box will not be a
> problem and this will obviously need to happen. Is it
> strictly necessary to go to MTS? I would be very happy
> if we could stick with what works reliably, plus I
> have read that MTS does respond as quick as dedicated.
> Does anybody have any advice on this one?
>
> Thanks for your time.
>
> Dave
>
>
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
>
> --
> Posted from web14407.mail.yahoo.com [216.136.174.77]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Wed May 23 2001 - 14:13:43 CDT