I might be totatly off here, but I think it depends on
the type of the pool. For example in OCI land there
are two - connection pool and session pool. The former
is stateful, while the latter is stateless. Again
unless I am totally off base, with a session pool I
think your session gets returned to a pool manager
(for potential re-use) after _about_ every statement,
effectively making tx:stmt relationship to become
about 1:1.
This is exactly what I am dealing with here and as a
result when user navigates on the screen the app
server instead of issuing say 30 selects, adds
additional 30 implicit rollbacks, one after each
select.
This is also the reason I think I see pattern like
this for example all over on DMLs:
XCTEND rlbk=0, rd_only=0 -- explicit commit
here
WAIT #0: nam='SQL*Net message to client'...
WAIT #0: nam='SQL*Net message from client'...
XCTEND rlbk=1, rd_only=1 -- implicit rollback
right after commit due to OCITransRollback() call
Thanks,
Boris Dali.
- 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).
Post your free ad now!
http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boris Dali
INET: boris_dali_at_yahoo.ca
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 - 09:34:26 CST
