Figure 9-3. Shown is the Time Model System Stats section from the same Statspack report as shown in Figures 9-1 and 9-2. During the Statspack reporting interval, Oracle server processes consumed 16,749.8 seconds of CPU and Oracle background processes consumed 131.8 seconds of CPU.

Along with using Statspack or AWR to gather and report CPU consumption, you can also easily collect this information yourself. Simply gather the initial value, final value, and if you want, the consumption per second, over the desired time interval. Figure 9-4 shows a code snippet used to collect CPU consumption based on v$sys_time_model. During the 60-second interval, the Oracle instance processes consumed 82.4 seconds of CPU; that is, on average 1.37 seconds each second.

Figure 9-4. Shown is a code snippet used to collect and then determine instance CPU consumption, based on v$sys_time_model, over a 60-second interval. The CPU consumed (82.4s) and also the CPU consumed per second (1.37s) are displayed.