From oracle-l-bounce@freelists.org Tue Oct 4 13:13:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94IDLbm012217 for ; Tue, 4 Oct 2005 13:13:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j94IDEvX012189 for ; Tue, 4 Oct 2005 13:13:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AACA1F260D; Tue, 4 Oct 2005 13:12:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22143-09; Tue, 4 Oct 2005 13:12:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B45321F25DF; Tue, 4 Oct 2005 13:12:15 -0500 (EST) Date: Tue, 4 Oct 2005 13:09:59 -0500 From: "Cary Millsap" To: "'Oracle-L'" Message-ID: <2110.51371128449144.hotsos01.hotsos.com@MHS> In-Reply-To: Subject: RE: CPUs NOT getting consumed ? x-scalix-Hops: 1 Thread-Index: AcXJBq9ryipS6HOjSkSdu+M+NYI0bAAB67Eg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C5C8E4.ECB85810" X-archive-position: 26291 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Cary.Millsap@hotsos.com Precedence: normal Reply-To: Cary.Millsap@hotsos.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_000C_01C5C8E4.ECB85810 Content-Type: text/plain; charset="us-ascii" Content-Disposition: inline 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 Nullius in verba Visit www.hotsos.com for curriculum and schedule details... _____ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Gogala, Mladen Sent: Tuesday, October 04, 2005 12:16 PM To: 'rjamya@gmail.com'; VIVEK_SHARMA@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@gmail.com] Sent: Tuesday, October 04, 2005 1:05 PM To: VIVEK_SHARMA@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 ------=_NextPart_000_000C_01C5C8E4.ECB85810 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Detailed discussion is available in M= illsap/Holt Optimizing Oracle Performance= , pages 141–149 and, perhaps of particular interest to Raj in light o= f Mladen’s comment, pages 161–165.

=

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

Visit www.hotsos.com for curriculu= m and schedule details...

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] <= span style=3D'font-weight:bold'>On Behalf Of Gogala, Mladen
Sent: Tuesday, October 04,= 2005 12:16 PM
To: 'rjamya@gmail.com'; VIVEK_SHARMA@infosys.com
Cc: Oracle-L
Subject: RE: CPUs NOT gett= ing consumed ?

CPU is measured only after the SQL s= tops executing. CPU consumption is NOT measured in real time.=

CPU consumption is meaningful only f= or the statements that are not being actively executed.=

--<= span style=3D'color:navy'>

Mladen Gogala

Ext. 121

From: rjamya= [mailto:rjamya@gmail.com]
Sent: Tuesday, October 04,= 2005 1:05 PM
To: VIVEK_SHARMA@infosys.c= om
Cc: Oracle-L
Subject: Re: CPUs NOT gett= ing consumed ?

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

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

------=_NextPart_000_000C_01C5C8E4.ECB85810-- -- http://www.freelists.org/webpage/oracle-l