so if user A has 10 DML statements to do in one transaction. The application server will be smart enough to to only allow user 'A' to use that connection until a 'commit' is issued?
how does application level connection pooling compare to MTS?
>
> From: Rachel Carmichael <wisernet100_at_yahoo.com>
> Date: 2003/12/15 Mon AM 09:04:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: RE: connection pooling from an application server to oracle
>
> nope..... the application server watches the connections and
> transactions
>
> the main problem is it's very hard to do a 10046 trace on a session
> with connection pooling going on, as a user session may actually be
> several distinct database sessions.
>
>
>
> --- ryan_oracle_at_cox.net wrote:
> > doesnt this force you to commit after every single DML statement?
> > >
> > > From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us>
> > > Date: 2003/12/15 Mon AM 08:36:09 EST
> > > To: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>
> > > CC: "'ryan_oracle_at_cox.net'" <ryan_oracle_at_cox.net>
> > > 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: ryan_oracle_at_cox.net [mailto:ryan_oracle_at_cox.net]
> > > 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: <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: <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).
>
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> 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: <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).
Received on Mon Dec 15 2003 - 08:24:25 CST
