查看内存参数
SQL> show parameter target;

配置AMM自动内存管理

SQL> alter system set memory_target=290m;
SQL> alter system set sga_target=0;
SQL> alter system set pga_aggregate_target=0;

当memory_target > 0，不设置sga_target 和 pga_aggregate_target，系统将自动调整sga_target和pga_aggregate_target，其中
的sga为60%，pga为40%。
（memory_max_target是memory_target的上限，不是动态参数
SQL> alter system set memory_max_target=301m scope=spfile;）

配置ASMM自动共享内存管理

(从手动内存管理到ASMM)
SQL> select (
2 (select sum(value) from v$sga) -
3 (select current_size from v$sga_dynamic_free_memory)
4 ) sga_target from dual;

SGA_TARGET
----------
199892992

计算出当前分配给sga的总内存量减去未使用的内存量作为sga_target

SQL> alter system set sga_target=199892992;
SQL> alter system set SHARED_POOL_SIZE=0;
SQL> alter system set LARGE_POOL_SIZE=0;
SQL> alter system set JAVA_POOL_SIZE=0;
SQL> alter system set DB_CACHE_SIZE=0;
SQL> alter system set STREAMS_POOL_SIZE=0;

（从AMM到ASMM）
SQL> alter system set memory_target=0;

SQL> alter system set SHARED_POOL_SIZE=0;
SQL> alter system set LARGE_POOL_SIZE=0;
SQL> alter system set JAVA_POOL_SIZE=0;
SQL> alter system set DB_CACHE_SIZE=0;
SQL> alter system set STREAMS_POOL_SIZE=0;

禁用ASMM
SQL> alter system set sga_target=0;

ITPub博客

AMM与ASMM

最新文章