RE: Shared Server Mode Reliable with Oracle 10gAS?
- From: "Sam Bootsma" <sbootsma@xxxxxxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>, <gus.spier@xxxxxxxxx>
- Date: Wed, 22 Dec 2010 08:35:43 -0500
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@xxxxxxxxx]
Sent: December 22, 2010 2:03 AM
To: gus.spier@xxxxxxxxx
Cc: Sam Bootsma; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxxxxxxx>
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
Other related posts:
