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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: I have a task to size a new db server... Cary please read

Re: I have a task to size a new db server... Cary please read

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 9 Apr 2004 16:46:37 -0700 (PDT)
Message-ID: <20040409234637.37401.qmail@web20416.mail.yahoo.com>

Sorry that I didn't get back on this earlier.

Cary - in your text, you mentioned the rather non-scalability of SMP on win32.

in single use type statements on this server, I tend to see about 13,000 LIOs per 100 MHz of CPU, where cpu time and clock time are nearly the same in a lightly loaded system.

if in fact, in 4-way SMP, we're only seeing 5,700 LIOs per 100 MHz of CPU, all else being equal, then we're seeing huge degradation as compared with "linear" scalability of SMP.

has anyone seen any papers regarding LIOs / second / 100 MHz CPU vs. # CPUs for Intel 32 bit CPUs? Athlons/Opteron?
SPARC? I would expect a first-order response (non-linear).

I think I smell a research project, but no time soon, as I'm on vacation all next week. Off to work on the old disc golf game and assist a friend on getting his new brewpub up and running.

thanks,

Paul



Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Apr 09 2004 - 18:42:58 CDT

Original text of this message

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