RE: Any exp with NTw/2 to 4 hamster wheels?

There was an interesting article (I believe it was on orapub) dealing with this phenomenon. If I remember correctly, the idea was that increasing one resource could decrease performance by shifting the existing bottleneck. For example, if the instance runs a mix of batch jobs and OLTP, with the batch being CPU bound, adding more CPU would allow better batch performance (bbp). The batch job might now bottleneck on IO, decreasing OLTP performance.

Henry

-----Original Message-----
From: Eric D. Pierce [mailto:PierceED_at_csus.edu] Sent: Wednesday, December 06, 2000 3:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Any exp with NTw/2 to 4 hamster wheels?

i think a better question is: "why *wouldn't* you see a performance increase?". you put more hamsters on more wheels, more things will spin around faster w/ greater torque, no? ep

On 6 Dec 2000, at 6:20, The Oracle DBA wrote:

> A client seems to be seeing now perf improv with adding 2 more
> procs to a 2 proc NT box. Anyone see a similar result? This is 805
> on NT 4.0 SP5.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).