RE: Shared Server vs. Connection Pooling
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Feb 2004 11:42:33 -0600
Jonathan
My initial reaction is that this would be a function of your application
server. Is that what you mean by mid-tier client? We haven't investigated
this, but I understand the big-buck app servers claim they can connect to
multiple databases and fail over transparently. Of course reality may differ
from sales claims.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Monday, February 09, 2004 11:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Shared Server vs. Connection Pooling
Would anyone care to comment on the combination
of Transparent Application Failover and Connection
Pooling. If the (mid-tier) client has dedicated connections
that are shared, what does the client do when the instance
it is connect to suddenly dies ? Also, how do you deal
with load-balancing if the database end of the system
never sees new connections arriving, and therefore
doesn't have a chance to distribute connections between
instances after the initial period of client startup ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearances:
March 2004 Hotsos Symposium - The Burden of Proof
March 2004 Charlotte NC OUG - CBO Tutorial
April 2004 Iceland
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___February
____UK___June
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message -----
From: <ryan.gaffuri@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, February 09, 2004 1:10 PM
Subject: Shared Server vs. Connection Pooling
My shop is using connection pooling. It seems like the trend is towards
middle tier connection pooling and away from Shared Server. What do you
think? Anyone know any cases where Shared Server is a superior option to
middle tier connection pooling(other than the reduction in cost)?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
