Re: When to use multi-threaded server

<machl001_at_maroon.tc.umn.edu> wrote:
>Does anyone have any rule-of-thumb as to when it is appropriate to
>use a multi-threaded server? Is it based on the number of users?
>If so, about how many users make the overhead worthwhile? Any other
>considerations?
>

 From my experience, if you have several users running applications that made occasional access to the database, like forms applications in which a user does something, then thinks and after a while does something else, than you would profit from Oracle MTS, else, if you have "batch type" applications then the overhead of MTS can be too heavy, since the number of SQL requests sent by a single client can be very high and it's therefore better to have a dedicated server.

 In the environment on which I've verified this (Oracle 7.0.14, Alpha OSF/1, all users on host) we decided in the end to use a mixed environment, forms users
attached to MTS and "batch" users attached to dedicated servers. We've noticed also that running EXP with a MTS, for fairly large amount of data (> 500 Mb) had very good chanches to fail.

 Hope this helps.

   Renato

-- 

Renato Brazioli      Sodalia SpA              e-mail: brazioli_at_sodalia.it
                     Via del Brennero, 364    voice:  +39(461)316.154 (direct)
                     I-38100 Trento           fax:    +39(461)316.127
                     ITALY