单选题When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?()AThe V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETBThe V$PGA_TARGET_ADVIC

题目
单选题
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


相似考题
参考答案和解析
正确答案: B
解析: 暂无解析