Re: CPU load per db instance

You may not have access to this tool and it's not free, but HP's PerfView is great for plotting graphs "after the fact". Your scenario with "who's been busy the last hour" is a typical PV query.

Finn

On Nov 22, 2007 11:58 AM, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> v$osstat is your friend for this. Not sure if 9ir2 had this view.
>
>
> On Nov 21, 2007 8:07 PM, rjamya <rjamya_at_gmail.com> wrote:
> > Hi all,
> >
> > on a given server, with multiple db instances, is there a known method to
> see how much load individual db is putting on the system? when i say db, i
> mean who db, including all sessions, instance itself and all session.
> >
>
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l