Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How's your shared server doing?

Re: How's your shared server doing?

From: joel garry <joel-garry_at_home.com>
Date: 13 Sep 2006 15:56:48 -0700
Message-ID: <1158188208.674325.196320@e63g2000cwd.googlegroups.com>

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.shtml
Received on Wed Sep 13 2006 - 17:56:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US