Re: question about MTS

i believe (and I don't know much about jdbc), in jdbc you have to give a full connect string (as it would be in tnsnames.ora), where you can specify SERVER=MTS, and then track in on the Oracle level, whether it is actually an MTS connection.

On Sat, 23 Sep 2000 17:12:33 GMT, gdas_at_my-deja.com wrote:

>The oracle documentation states that in order to use the multi-threaded
>server option, that user processes must connect through sql*net v. 2 or
>net 8. Our application makes connections through jdbc and there is no
>installation of sql*net / net8 on the machines running the application.
>
>Everything is running fine, our application runs over a farm of
>application servers with each server running multiple processes, so a
>lot of connections get opened up on the oracle server. We do use
>connection pooling on the application level so we do have some control
>over the number of connections that the application opens up on the
>server. We initially set the pool too high and eventually our oracle
>database ran out of memory.
>
>As a second safeguard, in addition to the connection pool, I was
>thinking about moving oracle to MTS mode rather than it's current
>dedicated mode. However, the documentation implies that I would see no
>benefit from this because we do not use SQL*Net /Net 8.
>
>I'm hoping someone could confirm this.
>
>Thanks,
>Gavin
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
  Received on Mon Sep 25 2000 - 18:45:47 CDT