What is the difference between ASMM and AMM in oracle database?
Automatic Memory Management (AMM) is an oracle database memory management configuration option that comes to existence starting from Oracle 11g.
AMM automatically manages the memory size value of SGA and PGA through memory_target initialization parameter.
We just set a memory value to MEMORY_TARGET initialization parameter and oracle distributes the memory among the SGA and PGA automatically.
Automatic Shared Memory Management (ASMM) is memory management feature starting from Oracle10g and uses two parameters, sga_max_size and pga_aggregate_target for SGA and PGA respectively.
ASSM enables the database to automatically adjusts the sizes of the SGA components (Database buffer cache, shared pool, large pool, redo log buffer, java pool and streams pool) as the workload changes.