Re: CPU Per Exec - SQL Ordered By CPU Time
- From: Oracle Dba Wannabe <oracledbawannabe@xxxxxxxxx>
- To: harel.safra@xxxxxxxxx
- Date: Wed, 24 Nov 2010 10:02:02 -0800 (PST)
Looking at the run queue - it is higher than the number of cores on the server.
The server is pretty much at 85-100% utilization during this interval too. That
said, I was interested in whether the statistic included wait for cpu or as
you've mentioned the process being in the run queue, So I think that pretty
much
answers my question. thanks
________________________________
From: Harel Safra <harel.safra@xxxxxxxxx>
To: oracledbawannabe@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Sent: Wed, November 24, 2010 10:45:48 PM
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
>
>
Other related posts:
