Description of the illustration v_pga_target_advice.gif

The illustration shows a line representation of V$PGA_TARGET_ADVICE. The content of the graph shows the cache hit percentage as related to the value of the PGA_AGGREGATE_TARGET parameter.

The current setting and optimal value are displayed on the graph. At the optimal setting, the cache hit percentage is nearly 85%, approximately 35% higher than the current setting.

End of image description.