I'm at a new site, and getting a crash course in MTS. I believe the MTS configuration needs some work.

The LARGE_POOL_SIZE is set to 0. In another thread on the site, one of th Sams recommends 10mb per server process. I have searched Oracle docs, but cannot find a method to calculate the size of the Large Pool.

Besides preventing fragmentation of the Shared Pool, what are the advantages of using the Large Pool for MTS?

One more question. We seem to have a lot of LOCAL connections. Does it imply that the MTS feature is not in use?