Re: shared server implementation in Oracle 11G R2

While true, it's important to remember this statement applies to those connections that will be set up as shared server.

The database supports a mix dedicated and shared servers, and the dedicated servers continue to follow the dedicated server rules.

/Hans
Disclaimer: My opinions are my own, and do not necessarily reflect those of my employer.

On 2017-08-03 3:35 PM, Mladen Gogala wrote:
>
> With shared server PGA comes from SGA. That means that
> PGA_AGGREGATE_TARGET is not used, among other things. With the
> automatic shared memory management (ASMM), you don't need to allocate
> shared pool, but you do need to allocate significantly larger SGA.
> BTW, that is the case even with multithreaded implementation of 12c.
>
> Regards
>
>
> On 08/03/2017 02:34 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
>>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217

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