Re: CPU Per Exec - SQL Ordered By CPU Time

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: oracledbawannabe@xxxxxxxxx
  • Date: Wed, 24 Nov 2010 19:45:48 +0200

It probably includes the time the process was in the run queue but not on the CPU itself (cpu wait). Do you have matching OS statistics for the peak load? I'd look at CPU utilization and run queue length. 


Harel Safra

On 24/11/2010 19:03, Oracle Dba Wannabe wrote:

Hi,
With reference to AWR reports, during non peak and peak times I see the following: 
Non Peak:
CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id 
        
1,092   1,337   28,730  0.04    6.51    3kmnk9f1htbcc <#3kmnk9f1htbcc>


Peak:
CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id 
        
4,679   15,653  29,922  0.16    6.05    3kmnk9f1htbcc <#3kmnk9f1htbcc>
I'm wondering what would cause the CPU per Exec to be greater during the Peak time? I understand that its CPU Time/Executions. Does CPU time include wait for CPU time too? which would mean during the peak time since the system was overloaded or CPU bound we would expect to see CPU per exec increase for the same statement? 
Thanks

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2010