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
