RE: CPUs NOT getting consumed ?

  • From: "Cary Millsap" <Cary.Millsap@xxxxxxxxxx>
  • To: "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Oct 2005 13:09:59 -0500

Detailed discussion is available in Millsap/Holt Optimizing Oracle
Performance, pages 141-149 and, perhaps of particular interest to Raj in
light of Mladen's comment, pages 161-165.

 

 

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com <http://www.hotsos.com/> 
Nullius in verba

Visit www.hotsos.com <http://www.hotsos.com/>  for curriculum and schedule
details...

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Gogala, Mladen
Sent: Tuesday, October 04, 2005 12:16 PM
To: 'rjamya@xxxxxxxxx'; VIVEK_SHARMA@xxxxxxxxxxx
Cc: Oracle-L
Subject: RE: CPUs NOT getting consumed ?

 

CPU is measured only after the SQL stops executing. CPU consumption is NOT
measured  in real time.

CPU consumption is meaningful only for the statements that are not being
actively executed.

 

--

Mladen Gogala

Ext. 121

  _____  

From: rjamya [mailto:rjamya@xxxxxxxxx] 
Sent: Tuesday, October 04, 2005 1:05 PM
To: VIVEK_SHARMA@xxxxxxxxxxx
Cc: Oracle-L
Subject: Re: CPUs NOT getting consumed ?

 

I don't suppose your app will be continuously using CPU. If it is, you have
a beast of a problem to handle. Could it be that your processi is doing I/O
and hence not using CPU?

Another minor question, why are you worried that is isn't using the CPU.
Raj

Other related posts: