Figure 9-22 provides the metrics for our operating system investigation. While not shown, neither the network or memory subsystem is an issue.

Figure 9-22. Shown is the operating system analysis information entered into a firefighting diagnostic template. There is no CPU or IO bottleneck. Oracle is consuming 26.1% of the CPU resources, and based on vmstat observations and v$osstat data, CPU utilization is around 28%. The IO subsystem is responding to IO requests in less than 1 ms! All IO data was gathered from the Oracle v$sysstat performance view.

The CPU subsystem consists of a single four-CPU core. Based on both vmstat observations and v$osstat view data, on average, the CPUs are about 28% utilized. Over the 30-minute data collection interval, the CPU subsystem has the capacity to supply 7,203 seconds of CPU. Based on the Oracle service time analysis, Figure 9-21 shows Oracle consumed about 1,880 seconds of CPU, meaning Oracle consumed about 26% of the available CPU resources.