Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail From: "Billy" Newsgroups: comp.databases.oracle.server Subject: Re: pros/cons of dedicated vs. MTS connections? Date: 15 Sep 2005 00:01:12 -0700 Organization: http://groups.google.com Lines: 34 Message-ID: <1126767672.075011.278970@g49g2000cwa.googlegroups.com> References: <43274985$1@news.beasys.com> <1126678789.683773.95020@z14g2000cwz.googlegroups.com> <432850F4.4070402@bea.com> NNTP-Posting-Host: 198.54.206.91 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1126767677 2769 127.0.0.1 (15 Sep 2005 07:01:17 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 15 Sep 2005 07:01:17 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 CNTRRA20-PRX01 Complaints-To: groups-abuse@google.com Injection-Info: g49g2000cwa.googlegroups.com; posting-host=198.54.206.91; posting-account=wp5kwAwAAAAK-35tPJYPGFtR9KGfcge6 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251576 Joe Weinstein wrote: > I found this online commentary on MTS that > concurs with you and most others that MTS should be avoided in > most cases: > > http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm If you bothered to investigate a bit more, you would have seen that Burleson refered primarily to a paper dated 2001, done using Oracle 8.1. You would also seen that the paper's recommendation is: "The Oracle Multi-Threaded Server feature can dramatically reduce the memory requirements of user connections, at the expense of some additional complexity and at the risk of causing performance degradation. Basically, one might want to consider using MTS if a server is having significant memory problems (i.e., a very high degree of paging/swapping) and if the application is designed in such a way to make sharing of user connections feasible. In general, OLTP-type applications can be suitable for MTS, while batch, data warehouse, and decision support applications are usually not appropriate for MTS." Which is a sensible conclusion as OLTP systems are typically the ones that scale extremely well using MTS. Nor does this paper say that MTS is 'A Bad Thing' as many attempts to make it out to be. Also realise that what was true some years ago in Oracle, is not always true today. And that has been proven numerous times - to great embarresment of some that still live by the conclusions and recommendations made in years passed. -- Billy