Modifying Memory Settings – Automatic PGA Memory Management

Modifying memory settings for automatic PGA memory management involves using the Memory Advisors page of Database Control to modify the instance PGA size. This section assumes that automatic memory management is disabled, and that automatic PGA memory management is enabled.

To modify the instance PGA size:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server to view the Server subpage.

3. In the Database Configuration section, click Memory Advisors.

   The Memory Advisors page appears, with the SGA subpage shown.

4. Click PGA to view the PGA subpage.

5. Do one of the following:

   • In the Aggregate PGA Target field, enter a new size for the instance PGA.

   • Click Advice to use the PGA Advisor to help you choose a new instance PGA size.

   See Oracle Database Performance Tuning Guide for information about sizing the instance PGA.

6. When you have specified the new instance PGA size, click Apply.

   A confirmation message appears.