Re: CPU usage per schema

From: <yong321_at_yahoo.com>
Date: 4 Feb 2007 03:26:42 -0800
Message-ID: <1170588402.132892.317480@a75g2000cwd.googlegroups.com>

On Feb 3, 9:56 pm, schi..._at_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 Received on Sun Feb 04 2007 - 05:26:42 CST