CPU usage in a multi database environment

  • From: "Orlando L" <oralrnr@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 21 Nov 2006 18:40:54 -0800

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.

Other related posts: