Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How's your shared server doing?
NetComrade wrote:
> 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
>
I know this is scary, but have you tried renicing them? You might see an immediate worse performance problem (like they can't service queues fast enough), or you may free up the cpu's to do something else. I don't use them, because the whole concept is for scalability, not performance, but if you have a hog, renice could be Jenny Craig.
jg
-- @home.com is bogus. "...different people are good at different puzzles." http://ask.slashdot.org/askslashdot/06/09/13/1559207.shtmlReceived on Wed Sep 13 2006 - 17:56:48 CDT