[每日一题] 11gOCP 1z0-053 :2013-10-13 MEMORY_TARGE初始化参数..................................51
来源:互联网 发布:淘宝异地客服是真的吗 编辑:程序博客网 时间:2024/05/16 23:02
转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/12688487
正确答案ABC
这道题比较简单,MEMORY_TARGET参数是Oracle11g中才有的,下面我们这幅图很清楚的描述了Oracle内存的关系:
参数memory_max_target、 memory_target、sga_max_size、sga_target、pga_aggregate_target的关系:
(1) sga_target=0 ,pga_aggregate_target=0 -〉完全自动管理,SGA=memory_target*60% PGA=memory_target*40%
(2) sga_target=600(最小值) ,pga_aggregate_target=200(最小值) -〉memory_target=sga_target+pga_aggregate_target
(3) sga_target=600,pga_aggregate_target=0 -〉pga_aggregate_target=memory_target-sga_target
(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参数可以直接在内存上修改,马上生效而无须重启数据库。
gyj@OCM> select ISSYS_MODIFIABLE from v$parameter where name='memory_target';ISSYS_MOD---------IMMEDIATEgyj@OCM> show parameter memory_targetNAME TYPE VALUE------------------------------------ ----------- ------------------------------memory_target big integer 804Msys@OCM> alter system set memory_target=900M;System altered.sys@OCM> show parameter memory_targetNAME TYPE VALUE------------------------------------ ----------- ------------------------------memory_target big integer 900M
QQ:252803295
技术交流QQ群:
DSI&Core Search Ⅰ 群:127149411(2000人技术群:未满)
DSI&Core Search Ⅱ 群:177089463(1000人技术群:未满)
DSI&Core Search Ⅲ 群:284596437(500人技术群:未满)
DSI&Core Search Ⅳ 群:192136702(500人技术群:未满)
DSI&Core Search Ⅴ 群:285030382(500人闲聊群:未满)
MAIL:dbathink@hotmail.com
BLOG: http://blog.csdn.net/guoyjoe
WEIBO:http://weibo.com/guoyJoe0218
ITPUB: http://www.itpub.net/space-uid-28460966.html
OCM: http://education.oracle.com/education/otn/YGuo.HTM
ACONG: http://www.acoug.org/category/membership
- [每日一题] 11gOCP 1z0-053 :2013-10-13 MEMORY_TARGE初始化参数..................................51
- [每日一题] 11gOCP 1z0-053 :2013-10-2 virtual private catalogs.......................................13
- [每日一题] 11gOCP 1z0-053 :2013-10-1 persistent lightweight jobs...........................11
- [每日一题] 11gOCP 1z0-053 :2013-10-11 Flashback Data Archive属性.........................43
- [每日一题] 11gOCP 1z0-053 :2013-10-10 materialized view---- online redefinition ...................35
- [每日一题] 11gOCP 1z0-053 :2013-10-4 Database Replay feature..................................17
- [每日一题] 11gOCP 1z0-053 :2013-10-5 SQL Access Advisor.........................................23
- [每日一题] 11gOCP 1z0-053 :2013-10-7 the backup of MULT_DATA................................32
- [每日一题] 11gOCP 1z0-053 :2013-10-12 RESULT_CACHE在哪个池?.............................44
- [每日一题] 11gOCP 1z0-053 :2013-10-15 duplexing of the backups............................60
- [每日一题] 11gOCP 1z0-053 :2013-09-29 Flashback Data Archive ...................................6
- [每日一题] 11gOCP 1z0-053 :2013-09-30 ASMCMD.......................................................8
- [每日一题] 11gOCP 1z0-052 :2013-09-13 FAST_START_MTTR_TARGET.........................................A69
- [每日一题] 11gOCP 1z0-052 :2013-09-10 ABOUT ALERTS...............................................A50
- [每日一题] 11gOCP 1z0-053 :2013-10-3 large ASM files--- variable extent size....................15
- [每日一题] 11gOCP 1z0-053 :2013-10-6 significance of the CHANGE FAILURE ..................25
- [每日一题] 11gOCP 1z0-053 :2013-10-8 attribute for an individual disk group.....................73
- [每日一题] 11gOCP 1z0-053 :2013-10-9 backup with the KEEP option....................................33
- java环境变量配置
- 常用Hash算法(C语言实现)
- linux下vi命令大全
- 使用索引快速全扫描(Index FFS)避免全表扫描的若干场景
- IPv6相关RFC
- [每日一题] 11gOCP 1z0-053 :2013-10-13 MEMORY_TARGE初始化参数..................................51
- python实现模拟登录
- zoj 3471 Most Powerful 状态压缩dp
- 关于Google Chrome 浏览器的一些命令及用法
- 怎样保护好APK文件?
- Android系统权限和root权限
- Chrome中的开发者插件
- 安装WIN7时提示“缺少所需的CD/DVD驱动器设备驱动程序”的解决办法
- 怎样花两年时间去面试一个人