Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] Benchmark rate and ORACLE database?
Mladen - Excellent points. When someone points out the vendor with the
highest benchmark results, I ask "Jeff Gordon is a consistent NASCAR winner
and he drives a Chevrolet, does this mean that you will be buying a Chevy
next?". To me the published benchmark results have about as much to do with
database choice as NASCAR has to do with automobile choice.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, May 29, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
Oracle doesn't do heavy maths so integer benchmarks should matter the most.
My advice is not to rely on standardized benchmarks but to ask the vendor
for references and then check those references as step one and then organize
a
little benchmark of your own that would use typical transaction(s) of your
company as a measuring unit. Once upon a time, when the world was much, much
younger, there used to exist a thingy called "MIPS", which stood for
"Marketing
Invention for Pushing Sales" or "Millions Instructions Per Second", I'm not
sure
any more. Test was conducted by the program called "dhrystone", later made a
part
of the program suite called "linpack". The trick with that benchmark was
that
dhrystone, in it's compiled form, took 3.85k of memory. You guessed it, DEC
came
out with 4k CPU caches and the program was executed entirely from the CPU
cache,
thus falsely declaring VAX boxes to be several times faster then they really
were.
To further own the benchmarking process, DEC came up with "VUP" (no, it's
not a
dog, it stands for "Vax Units of Performance") which was a measure how many
times
is the measured system faster then VAX 782 (or MicroVAXII, later).
Naturally, DEC
used to own the process. DEC no longer exists, people do not remember VAXBI,
LAT,
DECNET, SET HOST, SET DEFAULT, VT220 or even the KED/EDT/EVE editors. DEC
was
notorious for benchmark cheating. Today, there is an independent
organization
for CPU benchmarks (www.specbench.org) and another one for relational
benchmarks
(www.tpc.org). Both are funded by vendors and notorious for the lack of
objectivity. CPU benchmarks are no longer the primary concern. People do, as
they should, conduct their own benchmarks to gage the needed machine
capacity.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com
-----Original Message-----
Sent: Thursday, May 29, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
I am compare the SUN server performance with ORACLE
database. Can anyone
tell me following 4 values which one most import for
ORACLE database:
CINT2000
CFP2000
CINT2000 rates
CFP2000 rates
Thanks.
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Thu May 29 2003 - 11:29:43 CDT