Re: CPU load per db instance
- From: Carel-Jan Engel <careljan@xxxxxxxxxx>
- To: john.kanagaraj@xxxxxxxxx
- Date: Fri, 23 Nov 2007 15:58:27 +0100
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
> http://www.linkedin.com/in/johnkanagaraj
> http://jkanagaraj.wordpress.com (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 **
> --
> //www.freelists.org/webpage/oracle-l
>
>
Other related posts:
