Message-ID: <432781E0.9040808@bea.com> Date: Tue, 13 Sep 2005 18:50:24 -0700 From: Joe Weinstein User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server To: ORA600 Subject: Re: pros/cons of dedicated vs. MTS connections? References: <43274985$1@news.beasys.com> <43276AE6.2040706@bea.com> <1126658743.294281.190130@g49g2000cwa.googlegroups.com> In-Reply-To: <1126658743.294281.190130@g49g2000cwa.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 216.148.48.12 X-Trace: news.beasys.com 1126662504 216.148.48.12 (13 Sep 2005 18:48:24 -0700) Organization: BEA SYSTEMS Inc Lines: 32 Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx02.iad01.newshosting.com!newshosting.com!uunet!dca.uu.net!spool.news.uu.net!ash.uu.net!news.beasys.com!not-for-mail Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251449 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 >