Re: MTS - Multi-threaded server

At a very high level, MTS is intended for OLTP (i.e. short-transactional) systems with a high number of users (> 300?), and dedicated servers for all the rest (including batch jobs). The memory (UGA and PGA) is allocated differently if you use MTS than if you use dedicated connections, but this is all happening on the server, not on the client. Generally, the initial creation of a dedicated connection takes longer than an MTS connection, unless the user can use a pre-spawned connection. But the difference is generally not really noticeable.

Daniel

"Randi Wølner" <randiwolner_at_hotmail.com> wrote in message news:<b54b7d$luc$1_at_oslo-nntp.eunet.no>...
> Hello,
> We are using Oracle 8.1.7.0.0 om AIX 4.3.3.
> A short - 'new to MTS'-question:
> Will there be any difference seen from the client side of the connection -
> depending on whether logging on to a Oracle database using MTS or not?
> By 'difference' I mean will there be more/less memory allocated in the
> client, will the process of logging on take more time etc..?
>
> Thanks,
> Randi Wølner
Received on Mon Mar 17 2003 - 15:17:09 CST