Apply Changes
There are five steps to use the Memory Management Page. This page documents Step 5.
Complete this step only if you want to apply your changes to the database.
To use the Memory Management Page
- Select A Memory Management Mode And Allocate Global Memory
- Review Your Changes Against The Charts
- Fine Tune Memory Components
- Review Your Changes Against The Charts
- Apply Changes
To Apply Changes
- Click Preview to open the Memory Management dialog.
- Review the content of the Memory Management dialog.
- Click Copy to Clipboard to save the SQL script that can be used to apply the changes to the database.
- Apply the script. For example, you may choose to paste the script into TOAD or SQL*Plus.
Notes:
- Wait until the changes you make to the database have been completed before reusing this Spotlight page.
- To restore a Spotlight connection that has become disabled because of an incorrect minimum size, restore the size of memory components manually to their previous values, and restart the database instance.
- When you resize memory in Manual mode, some resize operations may take a long time or even fail if sizes are set too low. If the database cannot shrink some components, you may need to apply changes by setting them in the spfile or pfile and restarting the database.
- If you did not start the database instance by using an spfile, you may need to modify the pfile [init.ora] manually when resizing memory components.
About the Memory Management dialog
| Important! |
The dialog will tell you if the database needs to be restarted for changes to take effect. |
| Memory Configuration |
Review the selected memory configuration:
- sga_max_size
- memory_max_target
- memory_target
- sga_target
|
| SQL Statements |
Review the calculated changes to memory components.
-
Are they actual or minimum values?
Note: Oracle may recommend that you shrink a memory component (for example, the Shared Pool) to a value smaller than that needed by a specific database or application.
Do NOT shrink the size of the component below that level. Modify Spotlight's recommendation instead.
- What is the scope of the change (memory, spfile or both)?
- Do you need to restart the database for any changes to take effect?
|
| Copy to Clipboard |
Click to save the SQL script that can be used to apply the changes to the database. |
| Close |
Click to close the Memory Management dialog. |
Related Topics
Spotlight on Oracle Drilldowns
