Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Shared Server vs. Connection Pooling

Re: Re: Shared Server vs. Connection Pooling

From: <ryan.gaffuri_at_cox.net>
Date: Mon, 9 Feb 2004 12:50:35 -0500
Message-Id: <20040209175033.UVTJ19763.lakemtao02.cox.net@smtp.east.cox.net>


We are using microsoft IAS from the .Net framework here for our middle tier. What it looks to do is open and close up to 200 dedicated connections for every sql statement. However, it queues them up at the middle tier.

I think. Ill have to grab one of our middle tier guys and ask them how it works.
>
> From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
> Date: 2004/02/09 Mon PM 12:34:11 EST
> 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
>
>
> ----- 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
> ----------------------------------------------------------------
> 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

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
-----------------------------------------------------------------
Received on Mon Feb 09 2004 - 11:50:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US