Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CPU usage in a multi database environment

CPU usage in a multi database environment

From: Orlando L <oralrnr_at_gmail.com>
Date: Tue, 21 Nov 2006 18:40:54 -0800
Message-ID: <4e0c9d990611211840r70898244la280b4f1016598eb@mail.gmail.com> 





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.


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


Received on Tue Nov 21 2006 - 20:40:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US