Re: CPU load per db instance

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Thu, 22 Nov 2007 23:17:51 -0800
Message-ID: <2ead3a60711222317w5f6dd359j656183c387cd807c@mail.gmail.com>

> 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 **
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 23 2007 - 01:17:51 CST