Get the App
SLTechnology News&Howtos  ›  Database  › 

Instructions for using AMM

Shulou Source: shulou.com Published: 2022-06-01 21:13:50 11月16日 Update

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.

Tags: Management memory parameters recommendations manual rationality manual environment production affirmation instructions for use Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information MySQL Docker Shulou Tech Info vpn