From oracle-l-bounce@freelists.org Tue Mar 29 13:56:16 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2TJuEUt028564 for ; Tue, 29 Mar 2005 13:56:14 -0600 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 j2TJuDem028558 for ; Tue, 29 Mar 2005 13:56:13 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CBB588A76E; Tue, 29 Mar 2005 13:54:18 -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 25136-08; Tue, 29 Mar 2005 13:54:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5222D8A769; Tue, 29 Mar 2005 13:54:18 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=dEhzgDZ3aKi1PJNJmy08LMQeFyB2BFXvmwUOeNiwW8HytrnYjUuBVyuEN65hbXM+l6mXWNgk8Yb8NI97WOTY3sBiRfTQnxNgT5CuhsmwriIQQ6qYx94DrsLTS1xqORz+hK5W1ptcbyhOccqlFwEJTtu1n/M2wOBPj6g0SSzYC/E= Message-ID: Date: Tue, 29 Mar 2005 18:52:29 +0000 From: Jared Still To: jametong@gmail.com Subject: Re: parse cpu and recursive cpu Cc: "sjaffarhussain@gmail.com" , "oracle-l@freelists.org" In-Reply-To: <424960d2.3335a78d.6495.6429@mx.gmail.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit References: <424960d2.3335a78d.6495.6429@mx.gmail.com> X-archive-position: 17793 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: It is best to not rely on the actual statistic numbers, as those can change between releases. select n.name, n.statistic#, s.value from v$statname n, v$mystat s where lower(n.name) like '%cpu%' and n.statistic# = s.statistic# / On Tue, 29 Mar 2005 22:04:15 +0800, jametong@gmail.com wrote: > Hello The Human Fly, > > just do the below query.:-) > > select * from v$mystat where statistic# in (8,233); > > Best regards, > > ======= At 2005-03-29, 21:24:57 you wrote: ======= > > >Hello List, > > > >How do I get the parse cpu and recursive cpu of the current sessions? > >I dont see anything related to this in the v$sql,v$sqltext or > >v$sqlarea. > > > >Basically, I want the sql statement which produces top session output of OEM. > > > >-- > >Best Regards, > >Jaffar, OCP DBA > >Banque Saudi Fransi > >Saudi Arabia > >---------------------------------------------------------------------------------------- > >"It is your atittude, not your aptitude that determins your altitude." > >-- > >http://www.freelists.org/webpage/oracle-l > > = = = = = = = = = = = = = = = = = = = = > > jametong > jametong@gmaill.com > 2005-03-29 > > > -- > http://www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l