Re: shared server implementation in Oracle 11G R2

From: Paul Drake <>
Date: Thu, 3 Aug 2017 18:28:43 -0400
Message-ID: <>


Did you consider the use of the 11gr2 feature of database resident connection pooling? The reduced connection overhead of shared but the power of dedicated.

I looked at it but it was a tool that looked nice on the shelf but never made it into use on the work bench.


On Aug 3, 2017 2:36 PM, "Beckstrom Jeffrey" <> wrote:

> Back in Oracle 9i, we had implemented shared server on 32-bit hardware.
> With migration to 10g and 64-bit hardware we eliminated shared server. Now
> on 11g r2 and thinking of implementing it until which time we can add
> memory to the server.
> Back in 9i days, shared server required a large_pool and did not use
> pga_aggregate_target. Is this still true?
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

Received on Fri Aug 04 2017 - 00:28:43 CEST

Original text of this message