Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Memory Management Page

Use the Memory Management page to safely explore various memory allocations and their hypothetical impact on database performance. There is an opportunity to apply changes if appropriate.

To open the Memory Management Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Tuning | Memory Management.

To use the Memory Management Page

  1. Select A Memory Management Mode And Allocate Global Memory
  2. Review Your Changes Against The Charts
  3. Fine Tune Memory Components
  4. Review Your Changes Against The Charts
  5. Apply Changes


Note: The Memory Management page uses Oracle Advisories to estimate the impact of memory allocations on database performance. Oracle Advisories estimates are based on the current behavior of Oracle memory components, on how database performance in Oracle will be affected by changes in memory allocation. This advice is based on the recent behavior of your system.

For more information on Oracle Advisories, see the Oracle Database Oracle Database Help Center on the subjects of Using the Memory Advisors and Using Advisors to Optimize Database Performance.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating