当前位置:操作系统 > Unix/Linux >>

[每日一题] 11gOCP 1z0-053 :2013-10-13 MEMORY_TARGE初始化参数

[每日一题] 11gOCP 1z0-053 :2013-10-13 MEMORY_TARGE初始化参数
 
 
正确答案ABC
   这道题比较简单,MEMORY_TARGET参数是Oracle11g中才有的,下面我们这幅图很清楚的描述了Oracle内存的关系:
 
 
参数memory_max_target、 memory_target、sga_max_size、sga_target、pga_aggregate_target的关系:
[html] 
(1)   sga_target=0 ,pga_aggregate_target=0 -〉完全自动管理,SGA=memory_target*60%   PGA=memory_target*40%  
[html] 
(2)   sga_target=600(最小值) ,pga_aggregate_target=200(最小值) -〉memory_target=sga_target+pga_aggregate_target  
[html] 
(3)   sga_target=600,pga_aggregate_target=0  -〉pga_aggregate_target=memory_target-sga_target  
[html] 
(4) sga_target=0,pga_aggregate_target=200  -〉sga_target=memory_target-pga_aggregate_target  

 

 
答案解析:
答案A正确,memory_target参数的值可以小等等于memory_max_target参数的值,看下面的图。
 
 
答案B正确,如果memory_target参数不设,那么memory_max_target默认为0
答案C正确,如上图1-1,memory_target包括PGA和SGA
答案D不正确,memory_target参数可以直接在内存上修改,马上生效而无须重启数据库。
[html] 
gyj@OCM> select ISSYS_MODIFIABLE  from v$parameter where name='memory_target';  
  
ISSYS_MOD  
---------  
IMMEDIATE  
gyj@OCM> show parameter memory_target  
  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
memory_target                        big integer 804M  
sys@OCM> alter system set memory_target=900M;  
  
System altered.  
  
sys@OCM> show parameter memory_target  
  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
memory_target                        big integer 900M  

 


CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,