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: [Q] Benchmark rate and ORACLE database?

RE: [Q] Benchmark rate and ORACLE database?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 29 May 2003 08:29:43 -0800
Message-ID: <F001.005A5A9B.20030529082943@fatcity.com>


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.



Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
--

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

Author: mike mon
  INET: mccdba_at_yahoo.com
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).
--

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

Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com
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).
--

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

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
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

Original text of this message

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