Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16836 invoked from network); 21 Aug 2007 03:18:28 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 21 Aug 2007 03:18:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 753B072CED0; Tue, 21 Aug 2007 03:39:54 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07208-06; Tue, 21 Aug 2007 03:39:54 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3D05B72CCD9; Tue, 21 Aug 2007 03:39:53 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 21 Aug 2007 02:56:49 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7196D72CCF5 for ; Tue, 21 Aug 2007 02:56:49 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28812-05-4 for ; Tue, 21 Aug 2007 02:56:49 -0400 (EDT) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.236]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C6CA572D0FA for ; Tue, 21 Aug 2007 02:56:45 -0400 (EDT) Received: by wx-out-0506.google.com with SMTP id i27so1394898wxd for ; Tue, 21 Aug 2007 00:35:18 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=k1bBZhlTyzg4OFS0e6O8Xal6E3ZjG/7JLdTfJiaHNI1tBB2lasrPtdFSLGiMefHDat8PxGT/QbmIvkRX/KeQgfiu95aKGCg9Wc2Ph4MWaxwlNLErty7/fwLZkBIQPzLAGk/kMMalYqaqPe4C2uzDB/6bNefBjmikhpQb3C6p+Ts= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YWYJdmwwf2lzybMlonMWbym6UV5hRt+bYas2E39tN2zeukR+aZbDHpZMQTJd9QfHgvzcdYeVCPWXZ27RxkEYBewd1LzPt8lHadf3OxfptdVh46LrghGFpTiIn9r0+LevwdgmQy5xTTvjUV50EyywR/a1R2U4FrcC1wNDQ3NstOM= Received: by 10.70.52.2 with SMTP id z2mr12192933wxz.1187681718470; Tue, 21 Aug 2007 00:35:18 -0700 (PDT) Received: by 10.100.110.8 with HTTP; Tue, 21 Aug 2007 00:35:18 -0700 (PDT) Message-ID: <962cf44b0708210035k64179e14p9601fca1b0d3740a@mail.gmail.com> Date: Tue, 21 Aug 2007 15:35:18 +0800 From: "Zhu,Chao" To: "LS Cheng" Subject: Re: is dispatcher cpu caculated in "CPU used by this session"? Cc: oracle-l In-Reply-To: <6e9345580708191023i1795d672l4a7f3933185ad9e7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <962cf44b0708190750j20fe5fa0heb28bcea6e1164be@mail.gmail.com> <6e9345580708191023i1795d672l4a7f3933185ad9e7@mail.gmail.com> X-archive-position: 806 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-to: zhuchao@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain I am nto sure either, can't find any information about it. But interesting that background process (like lgwr/dbwr) cpu usage, are not caculated inside (CPU used by this session). And , dispatcher process does not have a SID/serial# in v$process/session; On 8/20/07, LS Cheng wrote: > I would think so since the stat counts all sessions CPU usage... > > Thanks > > -- > LSC > > > > On 8/19/07, Zhu,Chao < zhuchao@gmail.com> wrote: > > > > hi, all, > > does anyone know whether statistics "cpu used by this session" also > > include the cpu used by dispatcher in shared server mode? > > > > -- > > Regards > > Zhu Chao > > www.cnoug.org > > -- > > http://www.freelists.org/webpage/oracle-l > > > > > > > > -- Regards Zhu Chao www.cnoug.org -- http://www.freelists.org/webpage/oracle-l