Chat now with support
Chat with Support

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

CPU Busy Alarm

The CPU Busy alarm occurs when the total CPU utilization of the system exceeds a threshold. The CPU may encounter a large number of requests, or you may have un-tuned SQL, which uses excessive amounts of CPU.

To determine where excessive amounts of CPU are being used, you can use:

  • The server’s operating system tool, such as top on Unix or Task Manager on Windows, to find out which processes use the most CPU.
  • The Top Sessions drilldown to find out if a particular session is using CPU excessively.
  • The SQL & Application Workload drilldown to find out which SQL uses a lot of CPU.

 

Related Topics

Top Sessions Page

SQL & Application Workload | Top SQL Page

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating