Re: Shared Server vs. Connection Pooling

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 9 Feb 2004 17:34:11 -0000
Message-ID: <01ac01c3ef32$eeb52cc0$6702a8c0@Primary>

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_at_cox.net> To: <oracle-l_at_freelists.org> 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon Feb 09 2004 - 11:34:11 CST