Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CPU load per db instance

Re: CPU load per db instance

From: Carel-Jan Engel <>
Date: Fri, 23 Nov 2007 15:58:27 +0100
Message-Id: <>

At a CT site we're amidst the development of such a tool. We combine statspack, ashpack (Kyle Hailey's 'Money for nothing, Ash for free' thingy) and nmon (yes it's AIX) reports together in one performance warehouse.
All servers upload to the same DB. With the tool (build in APEX) we can provide insight in resource usage at all the levels, in a coherent way. looking at a given time window, you can switch between various sources like statspack and nmon. nmon takes snapshots every 5 seconds, ashpack every 3, IIRC. When it reaches a level of sufficient matureness the thing might get open-sourced.

At this site every instance (and if there are more applications running on that instance, every application) has its own WLM class, assigning 'enough' CPU to that instance/app. The apps are split by running separate listeners for every instance and every app. Each listener gets its own WLM class, the server processes will inherit this class. Took some time to set up, but all the maintenance and management tools are scripted out pretty well now, and it works quite well!

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok) ===

On Thu, 2007-11-22 at 23:17 -0800, John Kanagaraj wrote:

> > I understand this this information changes few milliseconds, but like we
> > capture using statspack ... can we do something on the server itself and
> > show it by each db? Has anyone already done this before? OS is solaris8 and
> > 10, db version is 9ir2 or 10g.
> Raj,
> If you are using 10g, then you are in luck. V$OSSTAT will provide
> system level CPU usage and V$SYS_TIME_MODEL will provide Instance
> level CPU usage (add "DB CPU" for foreground and "background cpu time"
> for background together). For explanation, see the STATSPACK packages
> and the sprepins.sql script.
> Happy Thanksgiving,
> --
> John Kanagaraj <><
> DB Soft Inc
> (Sorry - not an Oracle blog!)
> ** The opinions and facts contained in this message are entirely mine
> and do not reflect those of my employer or customers **
> --

Received on Fri Nov 23 2007 - 08:58:27 CST

Original text of this message