Re: I have a task to size a new db server... Cary please read
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Apr 2004 16:46:37 -0700 (PDT)
--- Paul Drake <discgolfdba@xxxxxxxxx> wrote:
> --- "Nelson, Allan" <anelson@xxxxxxxxxxx> 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@xxxxxxxx <mailto:anelson@xxxxxxxx>
>
>
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
