自动内存分配

10G 共享内存自动调整 通过参数 SGA_MAX_SIZE，SGA_TARGET 实现对SGA 的自动调整。
11G 自动内存分配 AMM （Automatic Memory Management）主要的几个参数：

MEMORY_MAX_SIZE --MEMORY_TARGET所能设定的最大值。非动态可调。
MEMORY_TARGET --操作系统的角度上 Oracle 所能使用的最大内存值。动态参数

AMM实现对 SGA，PGA的自动调整。

想使用AMM 只需要设置这个两个参数即可。无效人为的调整SGA，PGA。使用了AMM就高枕无忧了，
真的不需要我们关系内存这部分了嘛？

让我们看看 MOS 的如下内容：

Resolving Issues Where Frequent Growth and Shrink of Sga Causes Latches Such as Library Cache Latch [ID 1477310.1]


Improving The Performance

1. Turn off automatic memory management by turning off SGA_TARGET=0.

2. Set _memory_broker_stat_interval =999:
alter system set "_memory_broker_stat_interval"=999;

 This will reduce the number of resize.

3. Apply patches for following bugs:
Bug 6528336 - Automatic SGA may repeatedly shrink / grow the shared pool
Bug 7189722 - Frequent grow/shrink SGA resize operations

Bug 7189722 is fixed in 10.2.0.5 and 11.2.0.1. Bug 6528336 is fixed in 10.2.0.4 and 11.2.0.1.

SGA Re-Sizes Occurring Despite AMM/ASMM Being Disabled (MEMORY_TARGET/SGA_TARGET=0) [ID 1269139.1]

This is expected behavior. in 11.2 for immediate memory allocation requests,
which added this as a new feature when automatic memory management was disabled.
Enhancement Bug:13340694 has been logged to provide a warning message in the alertlog
when such allocations occur to provide the DBA with an indication of a memory problem,
as otherwise this can result in the buffer cache being shrunk below the specified minimum value,
and hence lead to performance degradation.

Solution

Ignore the resize operation which is performed to prevent an ORA-4031 error from being raised,

or

set the parameter _MEMORY_IMM_MODE_WITHOUT_AUTOSGA=false in the instance to disable this feature with the consequence that in future an ORA-4031 error would be raised, e.g.:

connect / as sysdba
alter system set "_memory_imm_mode_without_autosga"=FALSE scope=both;
exit


这里可以看到 第一篇MOS是不使用 SGA 自动分配共享内存频繁出现的扩展回收出现
Latches ， 解决办法 不使用共享内存自动调整 或者隐含参数减少内存调整。

第二篇是 11GR2 的新特性。AMM关闭了，为了避免 ORA-4031 还会有个隐含参数进行内存的调整。可以通过设置隐含参数 disable 这个新特性。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25475140/viewspace-748603/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25475140/viewspace-748603/