Instructions for using AMM
The introduction of AMM by oracle 11g certainly makes sense, but the production environment recommends that AMM be disabled.
Automatic memory management (AMM): automatic memory management target automatic memory management 0, if LOCK_SGA = true, disable AMM
Automatic shared memory management (ASMM): memory_target=0 and sgaze targets
Manual shared memory management: memory_target=0 and sga_target=0 specify sga parameters such as share_pool_size and db_cache_size
Automatic PGA management: memory_target=0 and workarea_size_policy=auto and PGA_AGGREGATE_TARGET setting value
Manual PGA management: memory_target=0 and workarea_size_policy=manal specify PGA parameters such as SORT_AREA_SIZE. It is generally not recommended to manage PGA manually.
