RE: CPU usage in a multi database environment

Hey Orlando,  

I usually quit out of top and use ps. You'll see the database name in the CMD column....  

Myserver=> ps -ef |grep 3802
  oracle 15280 522 0 10:34:24 pts/5 0:00 grep 3802   oracle 3802 1 1 Nov 19 ? 22:44 oracleTESTDB (LOCAL=NO)    

Dave Best
david.best_at_cognos.com

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Orlando L Sent: Tuesday, November 21, 2006 9:41 PM To: oracle-l_at_freelists.org
Subject: CPU usage in a multi database environment

Hi all,    

I have a server with 6 Oracle databases running. How do I find out which processes are consuming the CPU?  

top shows something like this which does not help me:  

  PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

16475 oracle    11  26    2  698M  660M sleep   1:34  8.97% oracle
16477 oracle    11  46    2  697M  659M sleep   1:56  7.96% oracle
 7605 oracle    11  46    2  886M  850M cpu10  11:48  6.13% oracle
 1767 oracle    15  58    0  898M  842M sleep 184:54  0.66% oracle
14363 oracle     1  59    2  885M  841M sleep 448:25  0.28% oracle
 7603 oracle     4  52    2   15M 8848K sleep   0:19  0.27% sqlplus 
 
 

Orlando.  

     This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.

--
http://www.freelists.org/webpage/oracle-l