The Oracle instance statistics shown in Figures 5-8 and 5-9 were gathered on a four-CPU core server over a large interval of 1,560.15 minutes. This means during this interval, the database server had the capacity to provide up to 374,436 seconds (4 cores _ 1560.15 minutes _ 60 s/1 m) of CPU power. Since Oracle consumed 48,126 seconds of CPU, Oracle used 12.9% of the available CPU. If this instance were the only instance on the database server and no other processes were consuming CPU, adding 10% operating system overhead, the database server would probably be around 23% busy. At 23% utilization, the queue time is not significant, and the average run queue will surely be less than the number of CPU cores. Since there are four CPU cores, we can surmise the average run queue is between zero and four. (If this is a surprise, please review the previous chapter, which covers the operating system.)

Figure 5-8. This time model statistics snippet is from a 26-hour interval Oracle Database 10g Statspack report. During the Statspack report interval, Oracle server processes consumed 45,552 seconds of CPU and the background processes consumed 2,575 seconds of CPU.

Figure 5-9. This is the instance statistics (v$sysstat based) snippet from the Oracle Database 10g-based Statspack report shown in Figure 5-8. During the Statspack report interval, v$sysstat reports Oracle processes consumed 33,020 seconds of CPU, parsing consumed 1,877 seconds, and recursive SQL consumed 6,426 seconds.