Hi Anne, Maybe you can try "/usr/ucb/ps -aux" in Unix to find the CPU usage of the instance processes.
For example : Thu Mar 21 15:45:00 SGT 2002 USER PID %CPU %MEM SZ RSS TT S START TIME COMMAND orahrms 7312 6.4 10.0421864406560 ? S 14:29:34 3:47 oracleTEST (LOCAL= Hope it helps. Regds, New Bee -----Original Message----- From: Anne Yu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 12:49 AM To: Multiple recipients of list ORACLE-L Subject: CPU usage for each oracle instance Hey list, In the system accounting report, I can get the total CPU usage for ORACLE. However, I have 7 instances on this box. How can I get the total CPU usage for each Oracle instance? Any ideas? Million thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anne Yu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).