Re: Memory Problems (Apps 11i)

Hi

> MTS might be quite a bad idea. With MTS, in theory, you use less RAM.
> In reality, you need bigger SGA, because all PGA is allocated inside
> of it with MTS. As a result, you are going to have huge shared segment
> statically allocated, instead of many dynamically allocated processes.
> And if you miscalculated, users might have error messages "Unable to
> allocate 12 bytes of memory". I saw such problem with 10.7. Experiment
> with MTS in that organization survived only about 3 months.

It's matter of planning and number of concurrent connections. When you only have 50 users in system, MTS might not be worth the trouble.

Tanel. Received on Fri Mar 21 2003 - 13:00:36 CST