RE: connection pooling from an application server to oracle

Ryan,

This is becoming for normal. There are a lot of software pieces that do connection pooling - basically, everybody is plaing in everbody else's space.

I have a couple of projects where the app-server does the connection pooling. One using Dcom and the other IBM WebSphere.

>From your point of view, it's just one less thing to worry about. The
number of db connections will be relatively small. The app server keeps track of transactions. As long as they say it works, it's not your problem.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, December 15, 2003 7:59 AM
To: Multiple recipients of list ORACLE-L

The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS.

they compartmentalize stuff here, so Im having trouble figuring out exactly how this affects the database and how to monitor performance. All I know is that I see a handful of constantly open dedicated connections. I have been told that this is actually alot of users connecting to the database.

This concerns me. how do you handle transaction control in this type of environment? in this type of environment do you have to commit after every DML statement? since multiple users will access the database with the same conneciton?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).