Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!a75g2000cwd.googlegroups.com!not-for-mail
From: yong321@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: CPU usage per schema
Date: 4 Feb 2007 03:26:42 -0800
Organization: http://groups.google.com
Lines: 17
Message-ID: <1170588402.132892.317480@a75g2000cwd.googlegroups.com>
References: <1170510974.589079.146760@k78g2000cwa.googlegroups.com>
NNTP-Posting-Host: 58.34.123.151
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170588410 9989 127.0.0.1 (4 Feb 2007 11:26:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 4 Feb 2007 11:26:50 +0000 (UTC)
In-Reply-To: <1170510974.589079.146760@k78g2000cwa.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: a75g2000cwd.googlegroups.com; posting-host=58.34.123.151;
   posting-account=JpMAKQwAAABLDMST8mNv88o_ATaOYKGK
Xref: news.f.de.plusline.net comp.databases.oracle.server:193571

On Feb 3, 9:56 pm, schi...@gmail.com wrote:
> On my Oracle RDBMS server 9.2.0.6 RAC on one node I have 0 % idle
> time. I try ro find out top session and I indetify that. Now I neen
> some script to find out percentage CPU usage per schema ...
>
> TIA
> Me

Interesting question. How about periodically check v$sesstat for 'CPU
used by this session' and group all sessions with the same username
together? That gives you CPU usage per schema at the moment. If the
sessions usually log in for a long time, that's close to the aggregate
CPU usage per schema. If they log in and out quickly, how about
creating a logoff trigger to record that statistic somewhere?

Yong Huang