| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared Server vs. Connection Pooling
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_at_lifetouch.com
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Monday, February 09, 2004 11:34 AM
To: oracle-l_at_freelists.org
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
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)?
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |