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>

Paul Drake <discgolfdba_at_yahoo.com> wrote:
> --- "Nelson, Allan" <anelson_at_miswaco.com> wrote:
> > And I was reading Practical Oracle 8i. Jonathon
> > suggests 10,000 logical
> > I/O's per 100 MHZ of CPU
> >
> > Thanks
> >
> > > Allan L. Nelson
> > > Oracle DBA
> > > M-I L.L.C.=20
> > > (832) 295-2238 office=20
> > > (832) 351-4180 fax=20
> > > anelson_at_midf.com <mailto:anelson_at_midf.com>
>
>
> Quad PIII Xeon 900 MHz 2 MB cache.
> This is the interval that had the highest logical
> IOs
> per second, had poorly performing statements after
> upgrade from 8.1.7 to 9.2.0.4.
>
> 748.5 million consistent gets in 60 minutes.
> = 207921 consistent gets / second
> = 5776 consistent gets / 100 MHz CPU
>
> hth.

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