Re: pros/cons of dedicated vs. MTS connections?

MTS is really for 1000+ connections
It saves memory and # of processes, but do watch for large_pool_size, as that's where session memory resides in MTS

but as DA Morgan said, don't use it unless you have to..

On Tue, 13 Sep 2005 14:51:58 -0700, Joe Weinstein <joeNOSPAM_at_bea.com> wrote:

>Hi. I have an application which makes several (10-50)
>separate JDBC connections to an Oracle DBMS, and uses
>these connections indefinitely. Can you tell me any
>reason I would prefer or care about whether the DBMS
>is configured sa MTS or not?
>thanks
>Joe
>

.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Tue Sep 13 2005 - 17:24:11 CDT