I am using SunOS 5.8. On 11/21/06, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
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