Re: Oracle AWR - Time Model Statistics / background elapsed time < background cpu time
- From: Stefan Koehler <contact@xxxxxxxx>
- To: MARK BRINSMEAD <mark.brinsmead@xxxxxxxxx>
- Date: Fri, 13 Mar 2015 18:09:51 +0100 (CET)
Hi Mark,
yes, you are right in case of "Elapsed Time" and "DB CPU", but i am talking
about "background elapsed time" and "background CPU time" in the "Time
Model Statistics".
I already explained this in more detail in my previous reply to Phil:
//www.freelists.org/post/oracle-l/Oracle-AWR-Time-Model-Statistics-background-elapsed-time-background-cpu-time,1
AWR Elapsed Time ≈ 3600 seconds
Amount of CPUs = 160
background cpu time ≈ 47342 seconds
background elapsed time ≈ 33676 seconds
If your theory for "background elapsed time" would be true as well, the max
background elapsed time would also be round about 3600 seconds, but in my
case it is 33676 seconds. The definition for "background elapsed time" and
"background CPU time" is different as the documentation states as well.
Thank you.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
> MARK BRINSMEAD <mark.brinsmead@xxxxxxxxx> hat am 13. März 2015 um 17:32
> geschrieben:
>
> Stefan,
> You seem to be assuming only 1 CPU.
>
> On a system with 10 CPUs, you can accumulate 10 seconds of CPU in only 1
> second of elapsed time.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
