CPU Per Exec - SQL Ordered By CPU Time
- From: Oracle Dba Wannabe <oracledbawannabe@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 24 Nov 2010 09:03:40 -0800 (PST)
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
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
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:
