Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

CPU load per db instance

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 21 Nov 2007 15:07:23 -0500
Message-ID: <9177895d0711211207m3f024d34ua8fc57aac2b51f33@mail.gmail.com>


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.

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.

Thanks in advance you any ideas. I am searching web as well, but wanted to tap the collective wisdom first.



Best regards
Raj

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 21 2007 - 14:07:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US