Re: Oracle AWR - Time Model Statistics / background elapsed time < background cpu time

From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 13 Mar 2015 18:09:51 +0100 (CET)
Message-ID: <252231778.186981.1426266591483.JavaMail.open-xchange_at_app02.ox.hosteurope.de>

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: http://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: _at_OracleSK

> MARK BRINSMEAD <mark.brinsmead_at_gmail.com> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 13 2015 - 18:09:51 CET