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.
When operationg in Automatic PGA Memory Management mode,you can seek advice on increasing or decreasing the value of PGA_AGGREGATE_TARGET to influence the hit ratio for the PGA work areas.