Chat now with support
Chat with Support

Spotlight on Oracle 10.9 - 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

Review Your Changes Against The Charts

There are five steps to use the Memory Management Page. This page documents Steps 2 and 4.

Review your changes against the charts whenever you change the memory management mode, global memory, and fine tune memory components.

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

 

Chart Description Actions
Response Time

Shows the Oracle Advisory for the component selected in Memory Components.

Estimate how much total memory you should allocate in order to minimize response time.

Ensure the Calculated sizes of individual memory components are close to the sizes recommended by the Oracle Advisories.

Memory Configuration (MB)

Compares the total size of the Current Oracle memory components to the estimated size Calculated from Oracle Advisories.

  
Overall Response Time (estimated)

Compares the Current value for response time to the estimated value Calculated from Oracle Advisories.

Ensure the Calculated value for Overall Response Time is lower than the Current value.

Note: The charts are color-coded to match the Memory Components table.

 

Sample Charts

Sample Charts Description

Large values in the Overall Response Time chart are cumulative values used to provide advice and NOT actual database response times. (For example, this chart indicates that adopting Spotlight's calculated values for memory size should improve response times for the database, but it does NOT give specific values for response times.)

In the example shown, the blue All Advisories line estimates how the response time varies with the total memory allocated to ALL Oracle processes. The vertical orange line indicates the amount of Oracle memory allocated NOW. (In the example, it suggests that the current value is close to that recommended by the Oracle Advisory.)

Fine-tune and review the allocation of memory components. To do so, use the Response Time chart to ensure that the Calculated sizes of individual memory components are close to the sizes recommended by Oracle Advisories.

  1. Click a row in Memory Components to display the Oracle advice for only that component in the Response Time chart.

  2. Find a point on the curve that indicates sufficient performance for the memory required. The X-axis at this point shows how much memory is required to obtain this level of performance.

    In this example, the current memory size (broken vertical line) of about 270 MB provides close to the best performance, where a size of 200 MB would not.

  3. Repeat the procedure for all relevant memory components.

 

Related Topics

Spotlight on Oracle Drilldowns

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating