Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CPU usage per schema

Re: CPU usage per schema

From: <schimme_at_gmail.com>
Date: 3 Feb 2007 09:17:28 -0800
Message-ID: <1170523048.331818.163030@q2g2000cwa.googlegroups.com>


Hi Daniel,

Os is True64 Unix an i use os command
iostat (vmstat on other unix) , i use statpack but it statpack report did't gave me result of percentage of cpu usage per schema (schemaname from v$session) in moment on time ...

A Morgan je napisao/la:
> schimme_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
>
> 1. How did you determine 0% idle time?
> 2. What operating system?
> 3. StatsPack?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sat Feb 03 2007 - 11:17:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US