Modifying Memory Settings – Automatic Memory Management

Modifying memory settings for automatic memory management involves using the Memory Advisors page of Database Control to change the total memory size setting. The procedure for changing this setting differs depending on whether your desired new setting exceeds the current setting for maximum memory size. If the new setting exceeds the maximum memory size setting, then you must first increase the maximum memory size accordingly.

To modify total memory size (new value does not exceed maximum memory size):

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server.

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

   The Memory Parameters page appears.

4. Do one of the following:

   • In the Total Memory Size field, enter a new value that is less than or equal to the value in the current Maximum Memory Size field.

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

     The Memory Size Advice page appears.

     
     Description of the illustration memory_size_advice.gif
     
     

5. If you chose to use the Memory Advisor, then click a point on the curve to change the total memory size. Otherwise, go to Step 7.

   The new total memory size is displayed below the graph.

6. Continue clicking the curve until the desired value is displayed, then click OK.

   You are returned to the Memory Advisors page.

7. Click Apply.

   A confirmation message appears.

To modify total memory size (new value exceeds maximum memory size):

1. Go to the Database Home page, and log in as user SYS with the SYSDBA privilege.

   See "Accessing the Database Home Page".

   Note: You must log in as user SYS to change the maximum memory size, which is a static initialization parameter.

2. At the top of the page, click Server.

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

   The Memory Advisors page appears.

4. In the Maximum Memory Size (MB) field, enter a new value for the maximum total memory to allocate to the database.

   This value must be greater than or equal to the desired new value for total memory size.

5. Click Apply.

   A confirmation page appears, indicating that you must restart the database.

6. Click Yes and follow the guided instructions to restart the database.

7. After you have initiated the database restart, wait a few minutes, then click Refresh.

   The Database Home page appears.

8. Return to the Memory Advisors page.

9. Do one of the following:

   • In the Total Memory Size field, enter a new value that is less than or equal to the value in the current Maximum Memory Size field.

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

     The Memory Size Advice page appears.

10. If you chose to use the Memory Advisor, then click a point on the curve to change the total memory size. Otherwise, go to Step 12.

    The new size is displayed below the graph.

11. Continue clicking the curve until the desired value is displayed, then click OK.

    You are returned to the Memory Advisors page.

12. Click Apply.

    A confirmation message appears.