Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.