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

"Billy" <vslabs_at_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