oracle Memory-Related Parameters

The memory_target  parameter sets the system-wide usable memory and lets Oracle tune 
both the SGA and PGA, changing the values of the SGA and the PGA automatically based 
on the demands of the running Oracle instance. You can dynamically change the value 

for this parameter using the alter system  command.

--根据实例需要自动调整pga和sga的大小

•The memory_max_target  parameter sets the maximum value of memory Oracle can use. 
That is, the value you set for the memory_max_target parameter is the maximum value up 

to which you can adjust the memory_targetparameter’s value.---设置oracle可用的最大内存

You can enable automatic memory management by setting the value of the memory_target
parameter and the memory_max_targetparameter in the initialization parameter file when 
creating a new database. You can also add them later to the initialization parameter file after 
database creation, but you have to bounce the database for automatic memory management 
to take effect.---通过设置memory_target 的大小是oracle使用自动内存管理 

  memory_max_target= 500MB
• memory_target= 350MB
• sga_target= 0
• pga_aggregate_target= 0
This set of initialization parameters ensures that the server allocates 350MB of memory 
to Oracle right away. Oracle will allocate this memory among the SGA and the PGA. You can 
dynamically change the value of the memory_target  parameter up to the maximum of 500MB 
set by the memory_max_target  parameter. Note that you must set both the sga_target  and 
pga_aggregate_target  initialization parameters to 0 if you don’t want to set any minimum 
values for the sizes of the SGA and the PGA.---如果不想设置sga和pga的最小值要将sga_target 和

pag_aggregate_taret设置为0