oracle 11g 自动内存管理

Oracle 11g 在原来的基础上增加了以下两个初始化参数，用来完成Memory（SGA+PGA）的自动化管理

memory_max_target     ---该参数不能动态调整，修改后必须重启数据库    memory_target 最大能等于该值           
memory_target             --最大能分配的内存空间，可以动态调整    

 

 

可以使用以下方法查看当前的内存分配 

 

SQL> select component,current_size/1024/1024 as curr,min_size/1024/1024 as min,m
ax_size/1024/1024 as max from v$memory_dynamic_components;

COMPONENT                            CURR        MIN        MAX
------------------------------ ---------- ---------- ----------
shared pool                           304        288        304
large pool                             16         16         16
java pool                              16         16         16
streams pool                            0          0          0
SGA Target                            928        928        928
DEFAULT buffer cache                  576        576        592
KEEP buffer cache                       0          0          0
RECYCLE buffer cache                    0          0          0
DEFAULT 2K buffer cache                 0          0          0
DEFAULT 4K buffer cache                 0          0          0
DEFAULT 8K buffer cache                 0          0          0

COMPONENT                            CURR        MIN        MAX
------------------------------ ---------- ---------- ----------
DEFAULT 16K buffer cache                0          0          0
DEFAULT 32K buffer cache                0          0          0
Shared IO Pool                          0          0          0
PGA Target                            496        496        496
ASM Buffer Cache                        0          0          0

已选择16行。