首页 > 其他 > 详细

ocp-322

时间:2015-10-12 12:41:37      阅读:218      评论:0      收藏:0      [点我收藏+]

QUESTION NO: 322
When tuning Automatic PGA Memory Management, which of the following views will provide the
information specified?

A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase
PGA_AGGREGATE_TARGET. 

B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if
you change the value of PGA_AGGREGATE_TARGET.

C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the
V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA
Memory Management.

D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas
if you switch from Manual to Automatic PGA Memory Management.

Answer: A


当调优自动程序全局区内存管理,以下哪个视图将提供指定的信息?

A.如果你增加程序全局区集合目标, 程序全局区目标建议视图显示预测缓存命中率改善。

当工作在自动PGA内存管理模式,你可以寻求建议增加或减少PGA集合目标的值以影响 PGA工作区的命中 率。


ocp-322

原文:http://blog.csdn.net/xuejiayue1105/article/details/49071209

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!