Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: pros/cons of dedicated vs. MTS connections?

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

From: Joe Weinstein <>
Date: Tue, 13 Sep 2005 18:49:43 -0700
Message-ID: <>

Thank you very much. Much appreciated.

Mark Bole wrote:

> Joe Weinstein wrote:

>> Mark Bole wrote:
>>> Joe Weinstein wrote:

> [...]
>> Hi Mark! Yes I continue to forge my own posts! ;)
>> I have recently discovered I don't know everything. ;)

> [...]
>> I appreciate your confirmation about a dedicated server.
>> Is there any official Oracle documentation stating such
>> as clearly as that? Or can you point me to a post that
>> delineates why?
>> thanks again!
>> Joe Weinstein at BEA

> Joe:
> FWIW, following is an excerpt of an in-house e-mail I wrote in January
> 2002. This was Oracle version 8.1.6, as I recall (I don't recall the
> Java version, probably 1.2 or something). This test did not include a
> JDBC connection pool, but rather plain vanilla JDBC (OCI) connection
> initiated via a batch job. Since I cannot post anything more specific,
> this should be categorized as "anecdotal". However it was sufficient to
> convince the client (customer of both Oracle and BEA) to abandon MTS
> forever (and, incidentally, MTS isn't even a good or correct name, which
> is why it's known as "shared server" these days).
> "Here [spreadsheet attached] is some experimentally controlled data that
> I collected on the performance of MTS and Java. For the first time, I
> can say that I have seen some hard evidence of performance problems due
> solely to MTS vs dedicated server for Oracle. What's VERY interesting is
> that the difference is MUCH more pronounced when it's a matter of Java
> and Oracle processes running concurrently [on the same server]. The
> difference was almost negligible for pure Oracle-to-Oracle transactions
> (meaning, on our production database server, this experiment does not
> predict any great difference due to MTS, which I think we've seen to be
> the case).
> [...]
> "Results: for the portion of [...] which involves creating new tables
> from old tables, there was a very slight improvement under the dedicated
> server config. Also, the tests without MTS were more consistent (lower
> standard deviation). For the portion of the [...] run that involves
> Java code (the XML extract), the MTS results were 2-4 times slower, and
> the deviations (variance) were signifcantly higher."
> -Mark Bole
Received on Tue Sep 13 2005 - 20:49:43 CDT

Original text of this message