Percy Mistry wrote:Yes
If MEMORY_TARGET is set but sga_target and pga_aggregate_target are not set (zero) then is ASMM (Automatic Shared Memory Management) enabled ?
Meaning does it dynamically redistribute memory between the internal componets of the sga (db cache, shared pool, large pool) and pga (sort area,..) as needed ?Yes
Or does it require sga_target and pga_aggregate_target to be > 0 for that to happen ?No
VamshiDamidi wrote:Are you saying it will manage SGA pools but not PGA work areas, unless pga_aggregate_target is specified ? Even though workarea_size_policy would still be auto(default) ? I am curious what would be the default memory distribution for the pga work areas in that case.
ASSM means all pools managment minus PGA which mean you have to manually specify the PGA
Memory_target > 0 with SGA and PGA targets being 0 means ASMM + pGA memory managements