Re: Appropriate use of MTS

Sorrybut I think that is a way to simplistic answer.

In general one would enable MTS if the reasons for performance problems were a lack of memory available on the server. By enabling MTS it can be possible to drasticlly reduce the memoery required to maintian connections to the server. This memory can then be applied to increasing various areas in the SGA (db-block buffers maybe :) ). This reallocation of memory can then result in dramatic performance improvements

If you do enable MTS remeber to increase the shared pool, I beleive the it needs about 300KB per cxonnection.

BTW: In my experience, if you are working with 7.2+ there is no noticable slowdown from just enabling MTS. Sure in theory there must be an overhead, it's just it is very small and users will not see the difference, this was not true on earlier releases.

>>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?
>
>Very right.
>
>Throwing in a middle tier, without drastically rearranging logic to
>suit, slows things down by definition.
>
>Josh
>
Received on Thu Apr 23 1998 - 00:08:58 CDT