Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!feed4.newsreader.com!newsreader.com!newsh.newsreader.com!ellis.newsreader.com!not-for-mail
Subject: Re: pros/cons of dedicated vs. MTS connections?
From: xhoster@gmail.com
Date: 14 Sep 2005 15:16:19 GMT
Organization: NewsReader.Com Subscriber
Message-ID: <20050914111619.734$Fc@newsreader.com>
Newsgroups: comp.databases.oracle.server
References: <43274985$1@news.beasys.com> <1126678789.683773.95020@z14g2000cwz.googlegroups.com>
X-Trace: NewsReader.Com 2kpx,lv8gkY97a_Ox@2C_RHkdeyR285R+yTRkG3UQ0hqzQ
Lines: 31
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251495

"Billy" <vslabs@onwe.co.za> wrote:
> Joe Weinstein 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?
>
> Joe, I use MTS as a default. Have since 8i.  MTS works. And works well.
> Is not complex. Is not buggy or <insert other Usenet rumours here>.

I've had the opposite experience.  Best thing we did was toss MTS/SS out
the window.  Second best thing we did was toss the DBA who insisted
(without being able to formulate a coherent justification) on using MTS/SS
out the window.


> I have lost count of the number of times
> app servers fail to close connections when done (guess this can be
> called pooled connection leaking on the app server side).
....
> Or do you design and
> configure FROM THE START for a system to be scalable?

I like this juxtaposition.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB