which turns out to be a bug for my platform hp-ux. ________________________________ From: Oracle Dba Wannabe <oracledbawannabe@xxxxxxxxx> To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>; "harel.safra@xxxxxxxxx" <harel.safra@xxxxxxxxx> Cc: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx> Sent: Wed, November 24, 2010 11:19:46 PM Subject: Re: CPU Per Exec - SQL Ordered By CPU Time I cant actually tell, during both peak and non peak intervals the statistic os_cpu_wait_time has a value of ############# during both intervals ________________________________ From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> To: "harel.safra@xxxxxxxxx" <harel.safra@xxxxxxxxx>; "oracledbawannabe@xxxxxxxxx" <oracledbawannabe@xxxxxxxxx> Cc: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx> Sent: Wed, November 24, 2010 11:03:26 PM Subject: RE: CPU Per Exec - SQL Ordered By CPU Time 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.