RE: Shared Server Mode Reliable with Oracle 10gAS?

From: Sam Bootsma <>
Date: Wed, 22 Dec 2010 08:35:43 -0500
Message-ID: <>

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 [] Sent: December 22, 2010 2:03 AM
Cc: Sam Bootsma; 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 <> 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.



On Tue, Dec 21, 2010 at 4:51 PM, Sam Bootsma <> wrote:

Hello All,  

We have an Oracle 10gAS middle-tier server that connects to an Oracle 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 on AIX and Oracle 10gAS on Windows 2003.  


Sam Bootsma

Oracle Database Administrator  


Niall Litchfield
Oracle DBA

-- Received on Wed Dec 22 2010 - 07:35:43 CST

Original text of this message