Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU usage per schema
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
![]() |
![]() |