Re: CPU usage in a multi database environment

If you want to see it in top press "c". Not that it's the most
reliable method but since you mentioned it...
You are on Linux. Right?

On 11/21/06, Orlando L <oralrnr@xxxxxxxxx> wrote:
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.



--
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l


Other related posts: