Re: CPU usage in a multi database environment

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: oralrnr@xxxxxxxxx
  • Date: Tue, 21 Nov 2006 23:44:28 -0500

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: