{"id":743,"date":"2010-09-26T09:37:32","date_gmt":"2010-09-26T03:37:32","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=743"},"modified":"2016-01-07T11:31:09","modified_gmt":"2016-01-07T05:31:09","slug":"oracle-exadata-database-machines","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=743","title":{"rendered":"Oracle Exadata Database Machines"},"content":{"rendered":"

\"\"<\/a>
\nOracle is now promoting their new database on steroids solution. Its called Exadata database machines. \u00c2\u00a0Its a complete system by itself. \u00c2\u00a0Exadata machine a.k.a Oracle Database Machine includes \u00c2\u00a0Oracle Enterprise RAC servers, \u00c2\u00a0Exadata storage server and SAN storage, all of which are installed and pre configured. \u00c2\u00a0According to Oracle, all you have to do it provide power, network connectivity, \u00c2\u00a0go through few settings, start up the instance , copy the data onto this and off you go. \u00c2\u00a0 Exadata is not a simple solution and hence not a cheap solution, its on the pricey side. \u00c2\u00a0 If your business require extreme throughput and has lot of data, its definitely worth looking at the Exadata solution. Another opportunity for it is server consolidation. You might be able to consolidate few oracle instances to an exadata server thus reducing the overall cost of your IT. \u00c2\u00a0 Lets dive a little bit deeper.\"\"<\/a>
\nOracle combines this database technology with Sun and came up with an architecture that optimized the database with the i\/o technology. \u00c2\u00a0The hardware is designed to be Oracle database friendly and the storage software is designed to be Oracle database and hardware friendly, so the result : A screaming machine !
\nExadata server comes in three flavors: \u00c2\u00a0Quater Rack : \u00c2\u00a0Half Rack : \u00c2\u00a0Full Rack . \u00c2\u00a0With each step the processing power and i\/o throughput doubles. \u00c2\u00a0Here is a quick snapshot of different configurations :<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Full Rack<\/td>\nHalf Rack<\/td>\nQuarter Rack<\/td>\n<\/tr>\n
8x Database servers<\/td>\n4 x Database Servers<\/td>\n2 x Database servers<\/td>\n<\/tr>\n
2 Quad-Core Xeon E5540
\nProcessors<\/td>\n		2 Quad-Core Xeon E5540
\nProcessors<\/td>\n		2 Quad-Core Xeon E5540
\nProcessors<\/td>\n<\/tr>\n
72 GB RAM<\/td>\n72 GB RAM<\/td>\n72 GB RAM<\/td>\n<\/tr>\n
584 GB SAS HD<\/td>\n584 GB SAS HD<\/td>\n584 GB SAS HD<\/td>\n<\/tr>\n
14 Sun Oracle Exadata Storage Servers<\/td>\n7 Sun Oracle Exadata Storage Servers<\/td>\n3 Sun Oracle Exadata Storage Servers<\/td>\n<\/tr>\n
5.3 TB Exadata Smart Flash Cache<\/td>\n2.6 TB Exadata Smart Flash Cache<\/td>\n1.1 TB Exadata Smart Flash Cache<\/td>\n<\/tr>\n
40Gb\/Sec InfiniBand Switches<\/td>\n40Gb\/Sec InfiniBand Switches<\/td>\n40Gb\/Sec InfiniBand Switches<\/td>\n<\/tr>\n
1 mil Flash IOPS<\/td>\n500K Flash IOPS<\/td>\n225K Flash IOPS<\/td>\n<\/tr>\n
50K Disk IOPS (SAS)
\n20K Disk IOPS(SATA)<\/td>\n		25K Disk IOPS (SAS)
\n10K Disk IOPS(SATA)<\/td>\n		10K Disk IOPS (SAS)
\n4K Disk IOPS(SATA)<\/td>\n<\/tr>\n
Raw Disk Space:
\n100 TB (SAS)
\n336 TB (SATA)<\/td>\n		Raw Disk Space:
\n50 TB (SAS)
\n168 TB (SATA)<\/td>\n		Raw Disk Space:
\n21 TB (SAS)
\n72 TB (SATA)<\/td>\n<\/tr>\n
Data Load Rate: 5 TB\/hr<\/td>\nData Load Rate: 2.5 TB\/hr<\/td>\nData Load Rate: 1 TB\/hr<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Each of these needs at a minimum of Oracle Database 11g R2 EE, \u00c2\u00a0Oracle RAC and Oracle Exadata Storage Server Software. And these softwares are licensed apart from the hardware, so beware of the total sticker price. I will warn you its pretty eye-popping !
\nThe operating system is however Oracle Enterprise Linux, which is basically Red Hat Linux that Oracle optimized for the Oracle database.<\/p>\n

The technology of course is pretty interesting, one of the key factor is “magic” of the Exadata storage software : the storage server eliminates the need for traditional indexes as it keeps its own hash indexes on a 1MB block level at the storage server. So what does it mean, well, when the database server gets a query it sends the predicates to the storage server which uses its hash indexes to find the data and pass the data back to the database server which then can do the calculations or functions against it and send the data to the application. This \u00c2\u00a0ensures that only relevant data is passed to the database server through the infiniband switches.<\/p>\n

\"\"<\/a><\/p>\n

According to the Exadata experts the DBAs can hide (invisible) all the non primary \/ unique indexes or can even drop them. This saves wasted optimizing time and of course space. \u00c2\u00a0The flash cache ofcourse makes the data hits scream. \u00c2\u00a0The SGA and data cache is now totally maintained at the Exadata Smart Cache thus exponentially increasing the overall IOPS of the system. \u00c2\u00a0The Exadata storage software also allows you to use Hybrid Columnar Compression, which is another way to increase the throughput of the system. \u00c2\u00a0The solution is fully redundant.<\/p>\n

Oracle lets you upgrade from quarter rack to half rack or a full rack, but again its not cheap. \u00c2\u00a0The only gotcha I’ve seen is you cannot simply add storage to the solution, you need to by exadata servers and software and might also need to buy additional database servers depending upon your storage requirement. So when you budget your system, ensure that you forecast your growth thoroughly.
\nThe solution again is not for everybody, if you have a small to medium size IT shop, you probably wouldn’t need an Exadata machine not because you cannot use it, but because it will be too much to justify the cost. \u00c2\u00a0If your i\/o throughput requirement and the amount of data that you deal with is in multi TB, then you may have an opportunity to look one of these machines. \u00c2\u00a0Oracle needs to bring down the price of these machines or softwares required to run these machine. \u00c2\u00a0These solutions can easily run you from $750 K and up (hardware and software). \u00c2\u00a0Take a look at the price list from Oracle.<\/a> Between the time I started writing this article and reach this point, Oracle has made another addition to its Exadata family : a 8 x 8 core machine with 2 TB RAM and 5.4 TB Flash Cache. Now thats extreme !
\nTo read more into Oracle Exadata Database Machine, visit this link<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle is now promoting their new database on steroids solution. Its called Exadata database machines. \u00c2\u00a0Its a complete system by itself. \u00c2\u00a0Exadata machine a.k.a Oracle Database Machine includes \u00c2\u00a0Oracle Enterprise RAC servers, \u00c2\u00a0Exadata storage server and SAN storage, all of which are installed and pre configured. \u00c2\u00a0According to Oracle, all you have to do it […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[303,142,364],"tags":[365,368,385,369,953,384,366,382,383,370,367],"class_list":["post-743","post","type-post","status-publish","format-standard","hentry","category-database","category-linux","category-oracle","tag-exadata","tag-exadata-storage","tag-exadata-storage-software","tag-infiniband","tag-oracle","tag-oracle-11g-r2","tag-oracle-database","tag-oracle-database-machine","tag-smart-flash","tag-sun-servers","tag-sunfire-flash"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=743"}],"version-history":[{"count":15,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions"}],"predecessor-version":[{"id":1513,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/743\/revisions\/1513"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}