RE: CPUs NOT getting consumed ?

From: Cary Millsap <Cary.Millsap_at_hotsos.com>
Date: Tue, 4 Oct 2005 13:09:59 -0500
Message-ID: <2110.51371128449144.hotsos01.hotsos.com@MHS>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen
Sent: Tuesday, October 04, 2005 12:16 PM To: 'rjamya_at_gmail.com'; VIVEK_SHARMA_at_infosys.com 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_at_gmail.com]
Sent: Tuesday, October 04, 2005 1:05 PM
To: VIVEK_SHARMA_at_infosys.com
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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 04 2005 - 13:13:21 CDT