doesnt this force you to commit after every single DML statement? > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/12/15 Mon AM 08:36:09 EST > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: 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----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 7:59 AM > To: Multiple recipients of list ORACLE-L > Subject: connection pooling from an application server to oracle > > > 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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).