Re: CPU load per db instance
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Thu, 22 Nov 2007 23:17:51 -0800
> 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:
