RE: CPU usage in a multi database environment
- From: "Best, David" <David.Best@xxxxxxxxxx>
- To: <oralrnr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 10:38:04 -0500
Hey Orlando,
I usually quit out of top and use ps. You'll see the database name in
the CMD column....
Myserver=> ps -ef |grep 3802
oracle 15280 522 0 10:34:24 pts/5 0:00 grep 3802
oracle 3802 1 1 Nov 19 ? 22:44 oracleTESTDB (LOCAL=NO)
Dave Best
david.best@xxxxxxxxxx
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L
Sent: Tuesday, November 21, 2006 9:41 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: CPU usage in a multi database environment
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.
This message may contain privileged and/or confidential information. If
you have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any attachments,
delete it immediately from your system and notify the sender promptly by e-mail
that you have done so. Thank you.
Other related posts:
