421.When tuning Automatic PGA Memory Management, which of the fo

分类: 英语题型 发布时间: 2023-12-01 12:13 浏览量: 0

421.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.

正确答案是A