X

Enabling Real-Time Analytics With Database In-Memory

Do I still need Exadata now I have Oracle Database In-Memory?

Maria Colgan
Master Product Manager

Over the last few weeks I’ve been meeting with Oracle customers all across Europe to discuss Oracle Database In-Memory. During these discussions there was a common concern raised by nearly everyone I spoke to, “Do I still need Exadata now that I have Oracle Database In-Memory?”. So I thought it would be a good idea to address this question once and for all here on the blog.

Exadata has long been touted as the “best platform for running the Oracle Database”. The virtues of Exadata for dramatically improving database I/O performance are well documented and overwhelmingly supported by customer references. But is Exadata also the best platform for running Oracle Database In-Memory? After all, by definition an in-memory database avoids I/O by holding data in DRAM. Doesn’t that mean Exadata offers no additional benefits for running an Oracle Database In-Memory compared to similar x86 systems?

No, Exadata is definitely the best platform for running Oracle Database In-Memory. At least for any important database and below are the 10 reasons why I believe this is the case

If on the other hand, your in-memory database is small enough to fit entirely in DRAM, you can tolerate periods when not all the data is in memory, and you're performing read-only analytics and the occasional data loads, then Exadata may be overkill. But then again, if this was your situation, it’s unlikely you would be considering Exadata anyway.

10 Reasons to run Database In-Memory on Exadata

  1. You get a complete fault-tolerant In-Memory solution

    On Exadata, you can configure a complete fault-tolerant In-Memory solution by taking advantage of In-Memory Duplication (In-Memory mirroring). In-Memory mirroring allows in-memory extends (IMCUs) to be replicated across a RAC cluster in order to prevent any performance degradations if you were to lose a RAC node. In-memory fault-tolerance is only available on Oracle Engineered System.

  2. You can exceed DRAM limits and transparently scale across Memory, Flash and Disk

    On Exadata, your database can exceed the size of DRAM and scale to any size across memory, flash and disk, with complete application transparency. Exadata combines the highest performance in-memory analytics, with the highest performance on-flash analytics (including columnar caching) and the highest performance on-disk analytics. Combining In-Memory with flash and disk delivers a much more cost effective solution than an all in-memory solution, rather than requiring all data to reside on DRAM.

  3. Initial population of data into the In-Memory column store from storage is very fast

    When data is initially populated into the In-Memory column store it is read from disk. The faster you can read the data, the faster you can execute the population process. Exadata offers outstanding IO performance.

  4. The In-Memory Aggregation optimization, can be offloaded to Exadata storage cells

    With the introduction of Oracle Database In-Memory comes the new In-Memory Aggregation optimization, Vector Group By. The key vectors, used by Vector Group By to enhance both join and aggregation, are offloaded to the Exadata storage enabling faster aggregation on all data regardless of where it resides.

  5. Highly optimized for RAC clustering, with special low-latency cluster protocols over InfiniBand

    Exadata is highly optimized for RAC clustering, with special protocols
    over InfiniBand for low-latency cluster interconnect. RAC clustering is
    how Database In-Memory fault-tolerance is achieved and how large
    databases scale-out in memory. No other platform supports RAC with
    in-memory like Exadata does.

  6. Exadata is a database consolidation platform and Oracle Database In-Memory further enables consolidation opportunities

    Exadata is an ideal database consolidation platform and Oracle Database In-Memory enhances that value even further. In many ways Oracle Database In-Memory “completes” Exadata by applying in-memory performance techniques that are similar to those used on disk and flash.  Database consolidation is all about lowering costs and administration while also increasing performance.  Consolidation on Exadata allows customers to simultaneously optimize performance and cost by placing specific tables or databases in-memory while using extreme performance flash and high capacity disk to increase consolidation capacity.  The result is a solution that gives the speed of DRAM, the IOPs of flash, and the cost effectiveness of disk.

  7. Use of Oracle VM Trusted Partitions is allowed, reducing software license costs

    On Exadata, the use of Oracle VM Trusted Partitions is allowed, reducing software license costs. This is especially relevant for database options that require less compute power than a full server.

  8. Elastic configurations, allow you to buy what you need

    Exadata elastic configurations, introduced in Exadata X5, enable custom configurations that are perfectly tailored to specific workloads. If you need more memory but not a lot of storage capacity you can create that configuration and only purchase the Exadata servers needed for the job.

  9. Get it first on Exadata

    Exadata is the development platform for Oracle Database In-Memory. Issues are discovered and fixed on Exadata first. Exadata is also the primary platform for Oracle Database testing, HA best practices validation, integration and support. The same reasons it is the best platform for Oracle Database apply to Oracle Database In-Memory.

  10. Parallel Execution NUMA support

    For larger datasets, Oracle's parallel execution has always been used to improve scan performance by allocating multiple parallel server processes. The same is true for Oracle Database In-Memory. On Exadata, Database In-Memory and parallel execution are NUMA aware, allowing them to understands the exact memory layout and interconnect. Ensuring the fastest access to all data populated in-memory.

Join the discussion

Comments ( 1 )
  • Bhaskar Thursday, July 21, 2016

    Like we have an Exadata Servers which gives us the best I/O preformance with Storage Indexes. And now we have In-Memory coming up. I see most of my queries are running good with the Exadata and now I like to test the In-Memory solution for the same set of queries.

    As I plan to do my testing .. I like to ask you if there are any parameters to consider which helps me to determine the In-Memory works better than the Smart Scan Feature or like Smart scan vs Vector-Processing.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services