How to monitor CPU utilization through OEM Grid Control

The Host chart on the Performance page of the database displays various utilization information about the system which is hosting the database. We have to determine if the host system has enough resources available to run the database. Here resources refers to the the amount of CPU, memory, and disk resources that our system should be using to function the database properly. We can then verify that the database is not consuming too many of these resources.

To view details about CPU, memory, and disk utilization. Click Load Average on the right pannel of the Host chart. The Host page appears, showing the Performance subpage.

The Performance Summary view shown above is by default. The Performance Summary view displays metric values for CPU utilization, memory utilization, disk I/O utilization, and the top 10 processes ordered by both CPU and memory utilization.


Monitoring CPU Utilization

1. From the Database Home page, click Performance. The Performance page appears.

2. In the Host chart, click Load Average in the right pannel. The Host page appears, showing the Performance subpage.

3. Select CPU Details as shown above from the View list. The CPU Details view appears. This view contains statistics about CPU utilization, I/O wait times, and load gathered over the last hour. The top 10 processes are also listed ordered by CPU utilization.


4. Verify the current CPU utilization using the CPU Utilization chart as shown below.
The CPU Utilization chart shows CPU utilization over the last hour. The current value is displayed below the chart. During standard workload hours, the value should not exceed the critical threshold.

5. Click CPU Utilization. The CPU Utilization page appears.

This page contains CPU utilization statistics and related alerts generated over the last 24 hours.
Here the warning threshold is set at 80% and critical at 95%. So if we see CPU spikes anytime reaches these threshold then we need to investigate more on this.