RE: CPU usage for each oracle instance

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Sat, 23 Mar 2002 01:48:21 -0800
Message-ID: <F001.004318B6.20020323014821@fatcity.com>

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:AYu_at_sos.state.tx.us]
		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: AYu_at_sos.state.tx.us

		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: ListGuru_at_fatcity.com (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: clchan_at_nie.edu.sg

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: ListGuru_at_fatcity.com (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).

Received on Sat Mar 23 2002 - 03:48:21 CST