Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CPU used by this Session and Wait time

RE: CPU used by this Session and Wait time

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 30 Nov 2006 00:44:03 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF79C4FF@MSXVS04.trivadis.com>


Hi

> Why is Wait Time  = 3,189,073 so much greater than CPU
> used by this session = 1,895,903

Mhmm... Because the database spent more time waiting for that event than on the CPU. It seams obvious. Or not?

> Is it because its Idle event?

A wait event it's a wait event. No mater if Oracle defines it as idle or not. And, therefore, an event is really idle only if it's not affecting the response time... i.e. idle events are not always idle ;-)

> Service time=1,895,903
> Wait Time= 3,189,073/44.09 = 72330.98
> Responce time= 1,895,903 + 72330.98= 1968233.98
> CPU Other=1,895,903-186,843- 1,066,217=642843
> =>642843/1968233.98*100= 32.6%
> queue messages = 3,189,073/1968233.98*100=162%

I hope the ML note is not providing that formulae. If yes, it is broken.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2006 - 17:44:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US