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

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