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

ORA600 wrote:

> Hi Joe,
>
> Oracle will never recommend a particular connection method unless the
> case you present is very very clear and specific. I haven't come across
> any Oracle doc that specifically recommends one method over the other
> in generic terms. Both MTS and Dedicated connection mechanism are
> designed for specific uses. As many have mentioned here before, MTS has
> specific uses. It also has more bugs and shared pool issues :-)
>
> MTS in 9.2 and 10g is better. I know of sites who use MTS because with
> Decidated connections, their application just hangs or machine just
> crawls. These guys have 7000+ connections and they cannot scale. In
> such cases, MTS helps. But, the application is also very crappy which
> needs MTS to mask its shortcomings.
>
> In simple terms, you will sleep peacefully if you use dedicated
> connections. For 100 connections, just use dedicated. Make sure you
> don't connect/disconnect frequently. Stay connected as long as you can
> and execute your transactions.

I will, and thank you very much.
Joe

>
> cheers
> ora600
>
Received on Tue Sep 13 2005 - 20:50:24 CDT