Re: Appropriate use of MTS

Well, actually MTS really only saves you PROCESSES. By suing a shared server, you can reduce the number of processes. The amount of memory saved is fairly small as you are only moving stuff from the PGA to the SGA.

Thanks,
Andrew.

Tony de Lange wrote:

> MTS is normally used when you have a memory constraint on a server. It has
> an overhead on your SGA and performance but it may compensate by the memory
> that is freed up to the operating system.
>
> Richard Hansen wrote in message <353d356c.176217956_at_news.cadvision.com>...
> >In all my readings and uses of the multi-threaded server, I was ALWAYS
> >under the impression that, GENERALLY, one used MTS for resources
> >reasons, not for performance reasons.
> >
> >In other words if someone says "My server is running pretty slowly, I
> >want it to run faster", one doesn't turn on MTS. I'm correct, right?
> >
> >
Received on Thu Apr 23 1998 - 00:27:25 CDT