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. [EMAIL PROTECTED] -----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:[EMAIL PROTECTED] -----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
