Exadata Database Machine X2-2 or X2-8? Sure! Why Not? Part I.

I’ve been getting a lot of questions about why one would choose Exadata Database Machine X2-8 over Exadata Database Machine X2-2. That’s actually a tough question, however, some topics do spring to mind. I’ll start a list:

  1. The Exadata Database Machine X2-8 only comes in full-rack configurations. No way to “start small.”
  2. The Exadata Database Machine X2-2 only (immediately) supports Oracle Linux. If Solaris is attractive to you then the X2-2 is not an option at the time of this blog entry. That is slated to change soon.
  3. Database Host RAM. The aggregate database grid RAM in a full-rack X2-2 system is 768 GB but 2 TB with the X2-8. The list is quite long for areas that benefit from the additional memory. Such topics as large user counts (consolidation or otherwise), join processing, and very large SGA come to mind. And, regarding large SGA, don’t forget, the Exadata Database Machine supports in-memory Parallel Query as well.

Not on the numbered list is the more sensitive topic of processor power. While these sorts of things are very workload-dependent, I’d go with 16 Intel Xeon 7500 (Nehalem EX) processors over 16 Intel Xeon 5600 (Westmere EP) for most any workload.

So, readers, what reasons would motivate you in one direction or the other?

7 Responses to “Exadata Database Machine X2-2 or X2-8? Sure! Why Not? Part I.”


  1. 1 Vijaykumar Manthena September 28, 2010 at 1:12 pm

    Hi Kevin,

    Would you be able to conduct some webcasts on Exadata in the interest of the community. Oracle RAC SIG does a lot of such presentations and they help us a lot. If we can do something similar, I think it would be great.

    Regards
    Vijay

  2. 2 ikke October 9, 2010 at 1:30 pm

    I see one very big disadvantage to the X2-8 platform: stability. If you only have 2 servers running your database, any problem halves your power( also in case of online patching). So if you need good uptime, you either only use 50% of the power or you need a multirack installation.
    For me this would rule out X2-8 for any environment that needs only one rack.

  3. 4 Coold2 November 15, 2010 at 6:51 pm

    I would tend to agree with ikke, if you lose one server in an 8 server config, you still have 87.5% of the capacity remaining. Lose one out of two, and you have lost half. According to Oracle, if you have a large OLTP workload (one big one or lots of little ones), you may be better off with the larger memory footprint of the two node X2-8. For Warehouse environments, the 8 node scale out work better, they say.
    Seems a shame that we are only given a couple of server/ disk configs. We have a greater need for Server capacity than we do storage, so we could wind up buying addional Exadata racks just to get CPU power and wind up with way more storage than we need.

  4. 5 Waseem Parkar January 27, 2011 at 8:59 am

    Hi ,

    Guess with 2-node X2-8 we will see less Interconnect traffic and more capability per node. Perhaps that could be the reason for having lesser nodes.
    Would having lesser nodes bring down the electricity bill making it greener :)
    Thanks.

  5. 6 robinschatterjee December 24, 2012 at 4:31 am

    How does the x3 dynamic and the changed cpus tilt this question. Some napkin based calculations I did seem to put the x3 in a losing position cpu wise.


  1. 1 IOUG Podcast 05-OCT-2012 12c DB Revealed / Dell Buys Quest / Generic Exadata Machines | IOUG Blog Central Trackback on October 5, 2012 at 12:14 pm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,049 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

Follow

Get every new post delivered to your Inbox.

Join 2,049 other followers

%d bloggers like this: