Oracle-L: RE: CPU usage for each oracle instance

From: Anne Yu <AYu_at_sos.state.tx.us>
Date: Mon, 25 Mar 2002 06:13:30 -0800
Message-ID: <F001.00431E1E.20020325061330@fatcity.com>

Thanks Catherine, It might do the trick. I will create a script and give it a try.

Thanks again.

-----Original Message-----
Sent: Saturday, March 23, 2002 3:48 AM
To: Multiple recipients of list ORACLE-L

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).
--

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
--------------------------------------------------------------------