79984

To modify the instance PGA size:

1.    In EM Express, from the Configuratfon menu, select Memory.

The Memory Management page appears. If the database has either automatic shared memory management or manuał shared memory management enabled, then the PGA Advisor Graph appears as the second chart to the right of the Memory Settings section.

2.    Use the PGA Advisor graph to predict the estimated cache hit percentage for potential database cache sizes.

In the PGA Advisor graph:

■Potential values for the PGA_AGGREGATE_TARGET initialization parameter are represented on the horizontal axis of the graph. The unit size (for example, MB or GB) is also indicated on the horizontal axis. The current setting of the PGA_ AGGREGATE_TARGET initialization parameter is indicated by a blue dot.

■The corresponding estimated cache hit percentage values are represented on the vertical axis of the graph. The plotted values are expressed as a percentage relativc to the current setting of the PGA_AGGREGATE_TARGET initialization parameter.