I've seen even more extreme cases than this. In one situation each dedicated
server was consuming 20MB, it was a while ago so I don't remember the
details. This can result in huge memory requirements
Dan Norris wrote in message <6hq9ie$3h0$1_at_sky.net>...
>
>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
>
Received on Mon Apr 27 1998 - 19:18:55 CDT
