Don’t be Fooled by Oracle’s Smoke and Mirrors

Submitted by on September 29, 2011  |  13,169 views

Conor O’Mahony, an IBM employee, closely watches Oracle. In this post, Conor examines Oracle’s recent announcements related to its SPARC line of products. You can read more from Conor on his Database Diary blog.

This week, Oracle hosted a video and issued a press release with a series of announcements related to its SPARC line of products. I am going to take a few moments to examine those announcements.

Interestingly, during the course of their announcement Webcast, Oracle frequently used the purported success of their Exadata and Exalogic products to back up many of their assertions about the new SPARC offerings, even though neither Exadata nor Exalogic use their SPARC systems (at least not yet anyway). Also interesting was that they spent so much time talking about the SPARC SuperCluster and their latest SPECjEnterprise2010 benchmark result, yet it turns out that Oracle did not actually use their SPARC SuperCluster for either that benchmark result or their TPC-H benchmark result. They assembled a system that is similar to the SuperCluster, but it is not the SuperCluster. (Instead of using the ZFS storage appliance, this benchmark uses F5100 flash arrays to store the database completely on solid state drives.)

These tactics are symptomatic of the smoke and mirrors that plague these announcements. Let’s see what they actually announced:

  • They announced a SPECjEnterprise2010 benchmark result(1) that beat IBM’s best performance result in the same benchmark by over 2.4 times, delivered 20 percent higher performance per processor than IBM POWER7, and supposedly delivered 6.7 times better price/performance. Let’s have a look at these claims. Yes, Oracle do have a bigger benchmark result, but they also used a lot more hardware. Here are the details:

    Item Oracle IBM Comments
    App Servers 4 x 32 core SPARC T4-4 1 x 64 core Power 780 Oracle had 2x the number of cores
    Database Servers 2 x 32 core SPARC T4-4 1 x 32 core Power 750 Express Oracle had 2x the number of cores
    Database Server Memory 2TB (1TB per server) 512GB Oracle had 4x the amount of memory
    Storage Tier 8 Sun Fire 4270 M2 servers (48 cores) DS5300 Disk System Oracle had 48 additional cores for database I/O
    Storage Tier Memory 8 x 8GB of memory for added caching 8GB of cache Oracle had 8x the amount of disk cache
    Total HDD 72 x 2TB drives = 144TB 128 x 146GB drives = 18TB Oracle had 8x more database storage
    Total SSD 16TB None Oracle used 16TB of SSD for database; IBM used none.
    Database Integrity Checking Turned off Left on

    You can see that Oracle didn’t just use twice as much processor cores for this benchmark run. They also used a lot more server memory, additional storage processors, more storage memory, more hard disk drives, and solid state drives. You certainly need to take all of this into account when considering the relative performance of the systems. As well, of course, as the fact that they disabled integrity checking to boost performance, which is something that I doubt anyone would do in a production system.

    The other thing to be aware of is that Oracle very cleverly derived their own independent pricing analysis. And that pricing analysis did not compare the total costs for these systems; instead it compared only the application server portion of the costs. In other words, they chose to not consider the cost of the database software (which includes licensing both Oracle Database and Oracle RAC on 64 processor cores). If they did add that cost, the conclusions would have been very different. You can be sure that they took these steps for a very good reason :-)

  • They announced a TPC-H 1000GB benchmark result(2) that is currently in 10th place for performance. They then asserted that they “delivered over 2.4 times better performance per processor at 1/3 the price/performance than an eight processor IBM Power 780.” However, you should note that the IBM Power System’s result was not running IBM DB2, which of course is optimized with deep exploitation of the Power Systems platform to drive faster performance. The Power Systems result they refer to uses Sybase IQ.

    Also, if you look at the ratio of storage to database size, you will notice that the Oracle system needed more than 10 times more storage than the database size. Whereas the IBM result needed less than 4 times more storage than the database size.

    I also believe there is an error in their claim; the price/performance for the Oracle system is $4.20 (see UPDATE below), the price/performance for the IBM system is $6.85 USD, which is actually 2/3 the price/performance and not the 1/3 Oracle are claiming. Their cost comparisons are even more troublesome when you consider: Sun and Oracle TPC Price/Performance Tactics Revealed.

  • They announced a number of benchmarks for their own applications software. These are not industry standard benchmarks, but Oracle benchmarks based on internal testing.

Make no mistake, Oracle are aggressively trying to stem the tide of customers moving off of SPARC. To understand their desperation just look at the following chart showing the Unix market share numbers over the past decade:

Unix Server Market Share

In 2010, IBM Power Systems successfully displaced 712 Oracle/Sun installations. In the first half of this year, IBM have done this 362 times. I would love to hear from Oracle regarding how many customers moved in the opposite direction. For more details of this momentum, make sure to visit the Power Systems Web page.

Oracle knows that IBM Power Systems have superior performance, reliability, availability, security, and virtualization. Oracle knows that IBM Power Systems currently lead in a number of other industry benchmarks that they failed to mention. They know they have a fight on their hands to play catch up when it comes to the SPARC processors, and much of what they are doing right now is simply noise to cover up the real story.

UPDATE: For their TPC-H benchmark, Oracle used a 3-year term license, rather than a standard software license. They also used a special incident support offering, rather than their standard software support. If Oracle used their standard software licenses and their standard software maintenance, the price/performance for their TPC-H benchmark result would have been $7.91 per QphH (rather than the $4.20 per QphH they reported).

(1) Results from www.spec.org as of September 24, 2011. Oracle WebLogic Server 11g and Oracle Database 11g Release 2 with Oracle Real Application Clusters and Oracle Solaris running on a four-node SPARC T4-4 cluster (20RU), each system with four SPARC T4 3GHz processors, 40,104.86 SPECjEnterprise2010 EjOPS. WebSphere Application Server V7 on IBM Power 780 (16RU) and DB2 on IBM Power 750 Express, 16,646.34 SPECjEnterprise2010 EjOPS.

(2) Source: Transaction Processing Performance Council (TPC) www.tpc.org as of September 24, 2011. SPARC T4-4 server (4 sockets/32 cores/256 threads) 201,487 QphH@1000GB, $4.60/QphH@1000GB, 50,371 QphH@1000GB/per socket, available 10/30/11. IBM POWER 780 Model 9179-MHB server (8 sockets/32 cores/128 threads) 164,747.2 QphH@1000GB, $6.85/QphH@1000GB, 20,593 QphH@1000GB per socket, available 3/31/11.

  • db2man

    Why IBM not use on TPC-H 1000GB benchmark the DB2 DPF instead of Sybase IQ ? For cut overall price/query

    • Phil

      Do you know why IBM used Sybase and Linux on their Power 780 TPC-H results? Have you compared pricing of Sybase/ Linux vs DB2/AIX?.  IBM probably cant get much more performance out of DB2/AIX and the price delta is enormous which would impact significantly on the price/performance metric!

      • http://twitter.com/conor_omahony Conor O’Mahony – DB2

        Hi Phil,

        I’m not sure why.  But I’ll try to find out.

        By the way, DB2 has a great scale-out architecture for data warehousing.  It uses its DPF feature, which is true shared-nothing partitioning.  As you know shared-nothing partitioning is the most efficient scale-out architecture for data warehouse environments.

        Remember, this is a relatively small benchmark.  It is only a 1TB environment.  DB2′s last TPC-H result back in 2008 was for a 10TB environment.  Also, please remember that there have been huge changes in packaging and pricing for DB2 in the warehouse space.  DB2 pricing is now very competitive, either for the terabyte-based pricing or for the processor-based pricing.

        Regards,Conor.

    • http://twitter.com/conor_omahony Conor O’Mahony – DB2

      Hi db2man,

      I’m not sure why.  There are many reasons why product teams collaborate on benchmark systems.  I’ll ask around and try to find out why the systems team worked with Sybase on this.

      Regards,Conor.

  • Rg125

    Liz,

    You have a long history of attacking Sun/Oracle hardware on the basis of the number of cores required to beat IBM results.

    The obvious thing for you to do is use the same number of IBM cores and see what happens. After all talk is cheap; lets see some results.

    Richard 

    • http://twitter.com/conor_omahony Conor O’Mahony – DB2

      Hi Rg125,

      Did you accidentally post this comment in the wrong post?  This post doesn’t mention per-core comparisons.  Although, it may come up in the comment stream yet :-)  

      Given the disparity in benchmark systems and the difficult in comparing them, as well as the fact that software is typically licensed on a per-core basis, I think that per-core comparisons are not unreasonable.  But that’s just my opinion.

      Regards,Conor.

  • Pingback: Challenging Oracle’s SPARC SuperCluster Claims | Smarter Questions for a Smarter Planet

  • Phil

    Your arguments are full of holes. The SPARC T4 SPECjEnterprise2010 benchmark result beats IBM’s best performance result by over 2.4 times so even though Oracle used just 2x more cores, they are still proving greater performance per core versus Power7 which cant be denied. And so if you were to assume that both systems were running the *same* software (ie: Oracle DB/Weblogic or DB2/Websphere), the bottom line is that IBM has now been surpassed by Oracle.  Lets see what Power7+ can achieve and whether IBM can beat these SPARC T4 results!  And why doesn’t IBM come out with identical configurations to show its performance superiority?

    • http://twitter.com/conor_omahony Conor O’Mahony – DB2

      Hi Phil,

      Oracle’s leading result has 2.4 times faster than IBM’s leading result.  However, simply looking at this fact is only part of the story.  The other part of the story is that Oracle used a much bigger system to achieve that result.  You can see the details above.

      Because Oracle’s leading result has 2.4 times better throughput of IBM’s leading result, it doesn’t necessarily translate that Oracle’s SPARC SuperCluster is 2.4 times faster than the IBM Power 780.  It is fair to say that the Oracle benchmark configuration is 2.4 time faster than the IBM benchmark configuration for one particular workload.  However, that benchmark configuration also spent more money on memory, storage, and network switches.  That’s a lot of variables.

      Make no mistake… this is a good benchmark result for SPARC T4.  However, we must also be cognizant of the fact that benchmarks are like a game of leapfrog, and typically have a limited lifespan.  Only last year, IBM were crowing about their SPECjEnterprise2010 results. Right now Oracle is crowing.  With the next IBM result, it will likely be IBM again.  And so it will go on :-)

      As regards why one vendor will not run the exact same software configuration on both hardware systems, well that goes equally for Oracle as it does for IBM.

      Regards,Conor.

    • http://pulse.yahoo.com/_YKHWUIQL6CEZ36WDJHJBFPZFV4 Regina .r

      That reasoning is very wrong….Phil i assume ur an IT person then u shuld know that the servers core rshp on overall throughput isnt that direct….overall throughput depends on many things such as ammount of disks used, their rpm, type of disk in which case oracle had some SSD’s etc….
      so: Oracle had 2x the number of cores that weblogic used over WAS, Oracle had 2x the number of cores thats Oracle DB had over DB2, Oracle had 4x the amount of memory on DB, Oracle had 48 additional cores for database I/O, Oracle had 8x the amount of disk cache, Oracle had 8x more database storage, Oracle used 16TB of SSD for database; IBM used none.

      Kindly take all these factors into consideration and you must agree that we are not comparing Apples and Apples here.
      I’m just curios, what if IBM had done their rating with similar or twice more the resources as Oracle did……We’d be taking about 10 times performance or more than Oracle.

  • Phil

    Regarding your comments on TPC-H comparison, you should also pay attention to the price of the hardware and those cost differences! While the SPARC T4 system  + storage list price @ $753,392, IBM’s 22% slower/core Power 780 system + storage costs a whopping 63% higher at $1,229,968! And by the way, Oracle used Storage Redundancy Level 3 as defined by the TPC-H 2.14.2 specification which is the strictest level available.

    • http://twitter.com/conor_omahony Conor O’Mahony – DB2

      Hi Phil,

      I’m not sure if you saw my update.  Instead of using standard perpetual software licenses, Oracle use a 3-year term license for this benchmark run.  Instead of using standard software maintenance contract, Oracle use a special maintenance that works out at less than 1% (instead of the 22% they charge). If you take the Oracle benchmark system and use standard perpetual software licenses and standard software maintenance, then it dramatically changes the cost of their benchmark system.  Sticking with the 38.59 discounting they are using in the benchmark run, the total system price goes from approximately $1.5M to $2.6M.  That’s a big difference.  BTW, the total system cost for the IBM benchmark system is $1.1M.

      And again, it will be interesting to see what the next benchmark result brings…

      Regards,Conor.

  • Pingback: Oracle T4 No POWER7 or zEnterprise Killer « DancingDinosaur

  • Sumit

     I know Oracle always use such type of Tactics.

    But Mr. Conor your post seems like IBM official advertisement in place of Blog (where someone share thoughts).

    No-one trust you if you will write down in such a way and claim everything good about one company. 

    • http://twitter.com/conor_omahony Conor O’Mahony – DB2

      If Oracle make claims in the public domain, I think it is fair to expect that competitors will respond to those claims.  Especially if those claims are open to question.  After all, if competitors did not respond to Oracle claims, then I don’t believe it would be good for the industry at large.

      I work for IBM, and try to make that fact clear.  I have never claimed to be impartial.  I am partial to IBM.  I try my best to be even-handed.  Perhaps I don’t always succeed in this endeavor.  However, I do try.  For instance, I try to always back my position with facts.  I am happy to present the facts, and let readers judge for themselves…

  • http://pulse.yahoo.com/_YKHWUIQL6CEZ36WDJHJBFPZFV4 Regina .r

    Mr Conor O M, I have actually had experience on both Sun and IBM servers as well as the application servers but not the DB’s yet. I can say for sure that the Power processor beats the Spark any day…..and Websphere Apps Server ND V 7 & 8 is in a league of its own esp whenit comes to mobile apps via ajax, security, extensibility and manageability.
    I also agree that Oracle pricing is the most trecherous road one’s organization can find itself in!
    I liked your objectivity on the response!
    Much thanks

    Tony,