ocp-322

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 increasePGA_AGGREGATE_TARGET. B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change ifyou change the value of PGA_AGGREGATE_TARGET.C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how theV$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGAMemory Management.D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areasif you switch from Manual to Automatic PGA Memory Management.

Answer: A

---

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

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

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

---