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

Reply via email to