ORACLE内存分配和使用建议

1、OLTP系统

PGA_AGGREGATE_TARGET=(<Total Physical Memory> * 80%) * 20%

2、DSS系统

PGA_AGGREGATE_TARGET=(<Total Physical Memory> * 80%) * 50%

 

归纳如下：

SGA + PGA  <=  <Total Physical Memory> * 80%

 

即：

SGA_MAX_SIZE + PGA_AGGREGATE_TARGET <=  <Total Physical Memory> * 80%

 

进一步简化：

MEMORY_TARGET <= MEMORY_MAX_TARGET <= <Total Physical Memory> * 80%