Re: Appropriate use of MTS

That's not quite true. Think much larger... On a system running only one oracle7 database, and making about 700 connections, we were able to free up over 150Mb of memory by configuring/enabling MTS. In a dedicated environment, a PGA is allocated for each server, but in MTS, the UGA is used for each shared server's sort areas and the like. However, the amount of memory normally allocated to the PGA is not the same amount that is used for MTS. Memory is conserved!!

Dan

ozziboy_at_pacbell.net writes:

>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 Fri Apr 24 1998 - 10:02:38 CDT