Re: shared server implementation in Oracle 11G R2

Jeffrey,

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.

Paul

On Aug 3, 2017 2:36 PM, "Beckstrom Jeffrey" <JBECKSTROM_at_gcrta.org> 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
>
>

--
http://www.freelists.org/webpage/oracle-l