RE: Shared Server Mode Reliable with Oracle 10gAS?
Date: Wed, 22 Dec 2010 08:35:43 -0500
Message-ID: <4FA79D28B662AD44AA0351CE91BA749F42F6AD_at_TCCEML02.gbrownc.on.ca>
Thanks for your input. I was wondering myself if it made sense to use shared server mode with 10gAS, since there would then be two tiers of pooled connections. I was also looking for confirmation if using shared server mode from 10gAS to the database was typical, and it sounds like it is not.
Sam Bootsma
Oracle Database Administrator
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: December 22, 2010 2:03 AM
To: gus.spier_at_gmail.com
Cc: Sam Bootsma; oracle-l_at_freelists.org
Subject: Re: Shared Server Mode Reliable with Oracle 10gAS?
I'd entirely agree, although shared server mode wouldn't be my likely choice of connection mode for middle tier apps that are already using connection pooling anyway. It would seem kind of illogical.
On Wed, Dec 22, 2010 at 12:14 AM, Gus Spier <gus.spier_at_gmail.com> wrote:
Of course, it's up to you, but I would ask the consultant to identify specific, documented instances of packets sent to a wrong process. Either there's a bug (which is not impossible) or there was a misconfiguration or error in the implementation.
v/r,
Gus
On Tue, Dec 21, 2010 at 4:51 PM, Sam Bootsma <sbootsma_at_georgebrown.ca> wrote:
Hello All,
We have an Oracle 10gAS middle-tier server that connects to an Oracle 10.2.0.4 database in dedicated server mode.
A consultant told me that in shared server mode the Oracle dispatcher will sometimes (but very rarely) send packets to the wrong process on the Oracle 10gAS Apache side. If this were to take place then that would certainly create problems. Given this, is anybody running the shared server mode from Oracle 10gAS to the database? If so, is it working well for you? Have you ever encountered such a problem or heard of such a problem.
We are running Oracle database 10.2.0.4 on AIX and Oracle 10gAS on Windows 2003.
Thanks,
Sam Bootsma
Oracle Database Administrator
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 22 2010 - 07:35:43 CST