Spotlight on Oracle 10.9 - Getting Started Guide

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

Dialog Component	Description
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.