Re: CPU usage in a multi database environment
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: oralrnr@xxxxxxxxx
- Date: Wed, 22 Nov 2006 11:56:32 -0800
Orlando,
The following is a simple script that wraps up what everyone else is saying:
#!/bin/ksh
#
# Name: top20.ksh
# Purpose: Display the top 20 CPU consumers. Specify a SID to collect
# only those top procs related to that SID in a multi-db system
# Author: John Kanagaraj, DBSoft Inc/ Aug 2001
# Notes: Tested and works on Solaris - may need adjustment for other OS
#
uptime
echo "PID %CPU RUSER CPUTIME ELAPSED COMMAND"
if [ $# == 1 ]; then
ps -eo pid,pcpu,ruser,time,etime,args | grep $1 | sort -nr +1
| head -20 | awk '{print substr($0,1,80)}'
else
ps -eo pid,pcpu,ruser,time,etime,args | sort -nr +1 | head -20 | awk '{
print substr($0,1,80)}'
fi
On boxes which have multiple instances, you can supply the SID name as
a parameter which will then parse out the top 20 processes for that
database only. Great for checking Dev boxes which have four or five
instances running simultaneously.
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.
--
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is always inevitable; Discouragement is invariably optional
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
