Modifying memory settings for automatic Program Global Area (PGA) memory management involves using the PGA Advisor graph in Oracle Enterprise Manager Database Express (EM Express) to modify the instance PGA size. This section assumes that automatic memory management is disabled, and that automatic PGA memory management is enabled.
Note:
When you disable automatic memory management, automatic PGA memory management remains enabled by default.
To modify the instance PGA size:
In EM Express, from the Configuration menu, select Memory.
The Memory Management page appears. If the database has either automatic shared memory management or manual shared memory management enabled, then the PGA Advisor Graph appears as the second chart to the right of the Memory Settings section.
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 relative to the current setting of the PGA_AGGREGATE_TARGET
initialization parameter.
An orange line on the graph plots different values that can be specified for the PGA_AGGREGATE_TARGET
initialization parameter. Click any dot on the orange line to see an estimate of the percentage of cache hits for the PGA_AGGREGATE_TARGET
value represented by that dot.
In this figure, the PGA Advisor graph indicates that increasing the current value of the PGA_AGGREGATE_TARGET
initialization parameter will not increase the percentage of cache hit.
To change the value of the PGA_AGGREGATE_TARGET
initialization parameter:
Click Configure Memory on the Memory Management page.
The Initialization Parameters page appears.
Select the PGA_AGGREGATE_TARGET
initialization parameter and click Set.
The Set Initialization Parameter page appears.
In the Scope field, enter the scope for this change.
See "Viewing and Modifying Initialization Parameters" for more information about specifying a scope of Memory, or SPFile, or both.
In the Value field, enter the new value for the PGA_AGGREGATE_TARGET
initialization parameter.
Click OK.
A confirmation message appears.
See Also:
Oracle Database Performance Tuning Guide for more information about memory management modes