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).
Received on Mon Dec 15 2003 - 08:04:26 CST
