RE: CPU Per Exec - SQL Ordered By CPU Time
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "harel.safra@xxxxxxxxx" <harel.safra@xxxxxxxxx>, "oracledbawannabe@xxxxxxxxx" <oracledbawannabe@xxxxxxxxx>
- Date: Wed, 24 Nov 2010 11:03:26 -0700
Do you see an increase in os_cpu_wait_time during the same interval? You can
check this in the AWR report, or get current values directly in v$osstat.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Harel Safra
Sent: Wednesday, November 24, 2010 10:46 AM
To: oracledbawannabe@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: CPU Per Exec - SQL Ordered By CPU Time
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
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
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
