Re: CPU usage in a multi database environment

Hi,

For Solaris try:
prstat -t or prstat -T - this lists the CPU and memory usage summary for each user.

or

ps -eo pid,pcpu,args | sort +1n | tail

HTH,
Goran

On 11/22/06, Orlando L <oralrnr_at_gmail.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l