Chat now with support
Chat with Support

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

Performance Modeling

Note: Available for Oracle 10.2 and later.

Use Performance Modeling to predict Oracle's future use of database resources —CPU, memory, and disk I/O (disk latency and disk throughput). Performance Modeling reveals trends in the use of hardware resources, analyzes what causes resource consumption, and provides advance notification of impending problems caused by hardware limitations. Performance Modeling...

  1. Collects performance data over an extended period.
  2. Establishes relationships between database load and database resources.
  3. Predicts when (and under what conditions) database resources are expected to reach their full capacity.
  4. Provides an interactive model that you can use to predict:
  • The resources needed to handle hypothetical database loads.
  • The database load that can be supported by a hypothetical mix of CPU, memory, and disk resources.

 

To open the page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Predictive Diagnostics.

 

Performance Modeling

 

Configuration

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating