Spotlight on Oracle 10.9 - Getting Started Guide

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