How's your shared server doing?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 13 Sep 2006 03:43:48 -0400
Message-ID: <phdfg25baghov5a0tinldptfjgf720u5a2@4ax.com>

For months I had a ticket open with Oracle "excessive CPU usage by dispatchers". The general throught was that dispatchers barely do anything, since they just hand off requests, and they shouldn't really be CPU hogs. Could you share a similar output off your server? (this one handles 2500-3000 connections). This is a 4CPU machine.

$ps -eo c,pid,user,cmd | grep -v USER | sort -nr | awk '$1 != "0" { print $0 }'

40 32545 oracle   ora_d001_VCRS
40 32533 oracle   ora_d000_VCRS
39 32557 oracle   ora_d003_VCRS
39 32549 oracle   ora_d002_VCRS
16 27031 oracle   ora_s000_VCRS
11  7056 oracle   ora_s001_VCRS
11 27220 oracle   ora_s002_VCRS

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3
remove NSPAM to email Received on Wed Sep 13 2006 - 02:43:48 CDT