Re: O7 multi-threaded

In article <3r7nvk$b5j_at_jac.zko.dec.com>, roderick_at_eps.enet.dec.com (Lisa Roderick) says:

>MTS forces many users to share one server process. It's best on memory-poor
>systems and where overall system utilization isn't high.
>
>So, performance probably won't be better. Memory utilization will be, though.
>
>Why not use SQL*Net to connect directly to the database? It's worth testing both.
>In my testing, I supported 10% less users using MTS. E-mail me for more details.

Lisa,

Don't you mean that you supported 10% MORE users using MTS ?

Our brief testing showed that we could support many more MTS connections than dedicated connections purely based on the lesser memory usage on the server when using MTS.

You do need to expand the size of the SGA considerably to handle MTS, since the connection memory is now housed in the SGA rather than the general system memory.

But, we found that the performance difference between MTS and dedicated connections made MTS unacceptable. It was easier for us to spend a bit more money on memory for the server.

My 2 cents worth.

Regards,
Tony Cook Received on Fri Jun 09 1995 - 00:00:00 CEST