question about MTS

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 Sat Sep 23 2000 - 12:12:33 CDT