Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Appropriate use of MTS
Each process uses some memory which, by using a shared server, is returned
to the O/S.
I agree you probably won't save much in database memory usage.
ozziboy_at_pacbell.net wrote in message <353ED13C.74000CBA_at_pacbell.net>...
>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 - 06:05:04 CDT