Oracle Exadata X3 Database In-Memory Machine: Timely Thoughtful Thoughts For The Thinking Technologist – Part I

Oracle Exadata X3 Database In-Memory Machine – An Introduction
On October 1, 2012 Oracle issued a press release announcing the Oracle Exadata X3 Database In-Memory Machine. Well-chosen words, Oracle marketing, surgical indeed.

Words matter.
Games Are Games–Including Word Games
Oracle didn’t issue a press release about Exadata “In-Memory Database.” No, not “In-Memory Database” but “Database In-Memory” and the distinction is quite important. I gave some thought to that press release and then searched Google for what is known about Oracle and “in-memory” database technology. Here is what Google offered me:

Note: a right-click on the following photos will enlarge them.

 

With the exception of the paid search result about voltdb, all of the links Google offered takes one to information about Oracle’s Times Ten In-Memory Database which is a true “in-memory” database. But this isn’t a blog post about semantics. No, not at all. Please read on.

Seemingly Silly Swashbuckling Centered on Semantics?
Since words matter I decided to change the search term to “database in-memory”  and was offered the following:

So, yes, a little way down the page I see a link to webpage about Oracle’s freshly-minted term: “Database In-Memory”.

I’ve read several articles covering the X3 hardware refresh of Oracle Exadata Database Machine and each has argued that Oracle Real Application Clusters (RAC), on a large-ish capacity server, does not qualify as “in-memory database.” I honestly don’t see the point in that argument. Oracle is keenly aware that the software that executes on Exadata is not “in-memory database” technology. That’s why they wordsmith the nickname of the product as they do.  But that doesn’t mean I accept the marketing insinuation nor the hype. Indeed, I shouldn’t accept the marketing message–and neither should you–because having the sacred words “in-memory” in the nickname of this Exadata product update is ridiculous.

I suspect, however, most folks have no idea just how ridiculous. I aim to change that with this post.

Pictures Save A Thousand Words
I’m horrible at drawing, but I need to help readers visualize Oracle Exadata X3 Database In-Memory Machine at a component level. But first, a few words about how silly it is to confuse Exadata Smart Flash Cache with “memory” in the context of database technology.

But A Bunch Of PCI Flash Cards Qualify As Memory, Right?
…only out of necessity when playing word games. I surmise Oracle needed some words to help compete against HANA–so why not come up with a fallacious nickname to confuse the fact? Well, no matter how often a fallacy is repeated it remains a fallacy. But, I suppose I’m just being pedantic. I trust the rest of this article will convince readers otherwise.

If PCI Flash Is Memory Why Access It Like It’s a Disk?
…because the flash devices in Exadata Smart Flash Cache are, in fact, block devices. Allow me to explain.

The PCI flash cards in Exadata storage servers (aka cells) are presented as persistent Linux block devices to, and managed by, the user-mode Exadata Storage Server software (aka cellsrv).

In Exadata, both the spinning media and the PCI flash storage are presented by the Linux Kernel via the same SCSI block internals. Exadata Smart Flash Cache is just a collection of SCSI block devices accessed as SCSI block devices–albeit with lower latency than spinning media. How much lower latency? About 25-fold faster than a high-performance spinning disk (~6ms vs ~250us).  Oh, but wait, this is a blog post about “Database In-Memory” so how does an 8KB read access from Exadata Smart Flash Cache compare to real memory (DRAM)? To answer that question one must think in terms relevant to CPU technology.

In CPU terms, “reading” an 8KB block of data from DRAM consists of loading 128 cachelines into processor cache.  Now, if a compiler were to serialize the load instructions it would take about 6 microseconds (on a modern CPU) to load 8KB into processor cache–about 1/40th the published (datasheet) access times for an Exadata Smart Flash Cache physical read (of 8KB). But, serializing the memory load operations would be absurd because modern processors support numerous concurrent load/store operations and the compilers are optimized for this fact. So, no, not 6us–but splitting hairs when dissecting an absurdity is overkill. Note: the Sun F40 datasheet does not specify how the published 251us 8KB read service time is measured (e.g., end-to-end SCSI block read by the application or other lower-level measurement) but that matters little. In short, Oracle’s “Database In-Memory” data accesses are well beyond 40-fold slower than DRAM. But it’s not so much about device service times. It’s about overhead. Please read on…

High Level Component Diagram
The following drawing shows a high-level component breakout of Exadata X3-2. There are two “grids” of servers each having DRAM and Infiniband network connectivity for communications between database hosts and to/from the “storage grid.” Each storage server (cell) in the storage grid has spinning media and (4 each) PCI flash cards. The cells run Oracle Linux.

Exactly When Did Oracle Get So Confused Over The Difference Between PCI Flash Block Devices And DRAM?
In late 2009 Oracle added F20 PCI flash cards as a read-only cache to the second generation Exadata known as V2–or perhaps more widely known as The First Database Machine for OLTP[sic]. Fast forward to the present.

Oracle has upgraded the PCI flash to 400GB capacity with the F40 flash card.  Thus, with the X3 model there is 22.4TB of aggregate PCI flash block device capacity in a full-rack. How does that compare to the amount of real memory (DRAM) in a full-rack? The amount of real memory matters because this is a post about “Database In-Memory.”

The X3-2 model tops out at 2TB of aggregate DRAM (8 hosts each with 256GB) that can be used (minus overhead) for database caching (up from 1152 GB in the X2 generation). The X3-8, on the other hand, offers an aggregate of 4TB DRAM for database caching (up from the X2 limit of 2TB). To that end the ratio of flash block device capacity to host DRAM is 11:1 (X3-2) or 5.5:1 (X3-8).

This ratio matters because host DRAM is where database processing occurs. More on that later.

Tout “In-Memory” But Offer Worst-of-Breed DRAM Capacity
Long before Oracle became confused over the difference between PCI flash block devices and DRAM, there was Oracle’s first Database In-Memory Machine. Allow me to explain.

In the summer of 2009, Oracle built a 64-node cluster of HP blades with 512 Harpertown Xeons cores and paired it to 2TB of DRAM (aggregate). Yes, over three years before Oracle announced the “Database In-Memory Machine” the technology existed and delivered world-record TPC-H query performance results–because that particular 1TB scale benchmark was executed entirely in DRAM! And whether “database in-memory” or “in-memory database”, DRAM capacity matters. After all, if your “Database In-Memory” doesn’t actually fit in memory it’s not quite “database in-memory” technology.

Oracle Database has offered the In-Memory Parallel Query feature since the release of Oracle Database 11g R2.

So if Database In-Memory technology was already proven (over 3 years ago) why not build really large memory configurations and have a true “Database In-Memory? Well, you can’t with Exadata because it is DRAM-limited–most particularly the X3-2 model which is limited to 256GB per host. On the contrary, every tier-one x64 vendor I have investigated (IBM,HP,Dell,Cisco,Fujitsu) offers 768GB 2-socket E5-2600 based servers. Indeed, even Oracle’s own Sun Server X3-2 supports up to 512GB RAM–but only, of course, when deployed independently of Exadata. Note: this contrast in maximum supported memory spans 1U and 2U servers.

So what’s the point in bringing up tier 1 vendors? Well, Oracle is making an “in-memory” product that doesn’t ship with the maximum memory available for the components used to build the solution. Moreover, the Database In-Memory technology Oracle speaks of is generic database technology as proven by Oracle’s only benchmark result using the technology (i.e., that 1TB scale 512-core TPC-H).

OK, OK, It’s Obviously Not The “Oracle Exadata X3 Database In-DRAM Machine” So What Is It?

So if not DRAM, then what is the “memory” being referred to in Exadata X3 In-Memory Database Machine?  I’ll answer that question with the following drawing and if it doesn’t satisfy your quest for knowledge on this matter please read what follows:

Presto-magic just isn’t going to suffice. The following drawing clearly points out where Exadata DRAM cache exists:

That’s right. There has never been DRAM cache in the storage grid of Exadata Database Machine.

The storage grid servers’ (cells) DRAM is used for purposes of buffering and the metadata managing such things as Storage Index and mapping what HDD disk blocks are present (copies of HDD blocks) in the PCI flash (Exadata Smart Flash Cache).

Since the solution is not “Database In-Memory” the way reasonable technologists would naturally expect–DRAM–then where is the “memory?” Simple, see the next drawing:

Yes, the aggregate (22TB) Exadata Smart Flash Cache is now known as “Database In-Memory” technology. Please don’t be confused. That’s not PCI flash accessed with memory semantics. No, that’s PCI flash accessed as a SCSI device. There’s more to say on the matter.

Please examine the following drawing. Label #1 shows where Oracle Database data manipulation occurs. Sure, Exadata does filter data in storage when tables and indexes are being accessed with full scans in the direct path, but cells do not return a result set to a SQL cursor nor do cells modify rows in Oracle database blocks. All such computation can only occur where label #1 is pointing–the Oracle Instance.

The Oracle Instance is a collection of processes and the DRAM they use (some DRAM for shared cache e.g., SGA and some private e.g., PGA).

No SQL DML statement execution can complete without data flowing from storage into the Oracle Instance. That “data flow” can either be a) a complete Oracle database disk blocks (into the SGA) or b) filtered data (into the PGA).  Please note, I’m quite aware Exadata Smart Scan can rummage through vast amounts of data only to discover there are no rows matching the SQL selection criteria (predicates). I’m also aware of how Storage Indexes behave. However, this is a post about “Database In-Memory” and Smart Scan searching for non-existent needles in mountainous haystacks via physical I/O from PCI block devices and spinning rust (HDD) is not going to make it into the conversation. Put quite succinctly, only the Oracle Database  instance can return a result set to a SQL cursor–storage cells merely hasten the flow of tuples (Smart Scan is essentially a row source) into the Oracle Instance–but not to be cached/shared because Smart Scan data flows through the process private heap (PGA).

Exadata X3: Mass Memory Hierarchy With Automatic What? Sounds Like Tiering.
I’m a fan of auto-tiering storage (e.g., EMC FAST). From Oracle’s marketing of the “Database In-Memory Machine” one might think there is some sort of elegance in the solution along those lines. Don’t be fooled.  I’ll quote Oracle’s press release :

the Oracle Exadata X3 Database In-Memory Machine implements a mass memory hierarchy that automatically moves all active data into Flash and RAM memory, while keeping less active data on low-cost disks.

Sigh. Words Matter! Oracle Database does not draw disk blocks into DRAM (the SGA or PGA) unless the data is requested by SQL statement processing. The words that matter in that quote are: 1) “automatically moves” and 2) “keeping.” Folks, please consider the truth on this matter. Oracle doesn’t “move” or “keep.” It copies. The following are the facts:

  1. All Oracle Database blocks are stored persistently on hard disk (spinning) drives. “Active data” is not re-homed onto flash as Oracle press release insinuates. The word “move” is utterly misleading in that context. The accurate word would be “copy.”
  2. A block of data read from disk can be automatically copied into flash when read for the first time.
  3. If a block of data is not being accessed by an Exadata Smart Scan the entire block is cached in the host DRAM (SGA). Remember the ratios I cited above. It’s a needles-eye situation.
  4. If a block of data is being accessed by an Exadata Smart Scan only the relevant data flows through host DRAM (PGA) but is not cached.

In other words, “Copies” != “moves” and “keeping” insinuates tiering. Exadata does neither, it copies. Copies, copies, copies and only sometimes caches in DRAM (SGA). Remember the ratios I cited above.

Where Oh Where Have All My Copies Of Disk Blocks Gone?
The following drawing is a block diagram that depicts the three different memory/storage device hierarchies that hold a copy of a block (colored red in the drawing) that has flowed from disk into the Oracle Instance. The block is also copied into PCI flash (down in the storage grid) for future accelerated access.

Upon first access to this block of data there are 3 identical copies of the data. Notice how there is no cached copy of this block in the storage grid DRAM. As I already mentioned, there is no DRAM block cache in storage.

If, for example, the entirety of this database happened to fit into this one red color-coded block, the drawing would indeed represent a “Database In-Memory.” For Exadata X3 deployments serving OLTP/ERP use cases, this drawing accurately depicts what Oracle means when they say “Database In-Memory.”  That is, if it happens to fit in the aggregate Oracle Instance DRAM (the SGA) then you have a “Database In-Memory” solution. But, what if the database either a) doesn’t fit entirely into host DRAM cache and/or b) the OLTP/ERP workload occasionally triggers an Exadata Smart Scan (Exadata offload processing)? The answer to “a” is simple: LRU. The answer to “b” deserves another drawing. I’ll get to that, but first consider the drawing depicting Oracle’s implied “automatic” “tiering”:

I’ve Heard Smart Scan Complements “Database In-Memory”
Yeah, I’ve heard that one too.

The following drawing shows the flow of data from a Smart Scan. The blocks are being scanned from both HDD and flash block devices (a.k.a Smart Flash Cache) because Exadata scans Flash and HDD concurrently as long as there are relevant copies of blocks in flash. Important to note, however, is that the data flowing from this operation funnels through the non-shared Oracle memory known as PGA on the database host . The PGA is not shared. The PGA is not a cache. The effort expended by the “Database In-Memory Machine” in this example churns through copies of disk blocks present in flash block devices and HDD to produce a stream of data that is, essentially, “chewed and spat out” by the Oracle Instance process on the host. That is, the filtered data is temporal and session-specific and does not benefit another session’s query. To be fair, however, at least the blocks copied from HDD into flash will stand the chance of benefiting the physical disk access time of a future query.

The fundamental attributes of what the industry knows as “in-memory” technology is to have the data in a re-usable form in the fastest storage medium possible (DRAM).

We see neither of these attributes with Oracle Exadata X3 Database In-Memory Machine:

It Takes a Synopsis To Visualize The New “In-Memory” World Order
I’m not nit-picking the semantic differences between “in-memory database” and “database in-memory” because as I pointed out already Oracle has been doing “Database In-Memory” for years. I am, however, going to offer a synopsis of what is involved when Oracle Exadata X3 Database In-Memory Machine processes a block in an OLTP/ERP-style transaction. After all, Exadata is the World’s First Database Machine for OLTP and now that it is also Database In-Memory technology it might interest you to see how that all works out.

Consider the following SQL DML statement:

UPDATE CN_COMMISSION_HEADERS_ALL set DISCOUNT_PERCENTAGE = 99 WHERE TRX_BATCH_ID = 42;

This SQL is a typical OLTP/ERP rowid-based operation. In the following synopsis you’ll notice how an Exadata X3 Database In-Memory Machine transaction requires a wee-bit more than a memory access. Nah, I’ll put the sarcasm aside. This operations involves an utterly mind-boggling amount of overhead when viewed from the rosy lenses of “in-memory” technology. The overhead includes such ilk as cross-server IPC, wire time, SCSI block I/O, OS scheduling time, CPU-intensive mutex code and so forth. And, remember, this is a schematic of accessing a single block of data in the Exadata X3 Database In-Memory Machine:

  • On the Host
    • Oracle foreground process (session) suffers SGA cache lookup/miss
      • <spinlocks, SGA metadata block lookup (cache buffers chains, etc)>
    • Oracle foreground LRUs a SGA buffer
      • <spinlocks cache buffers LRU, etc>
    • Oracle foreground performs an Exadata cell single block read
      • Oracle foreground messages across iDB (Infiniband) with request for block
        • <reliable datagram sockets IPC>
      • Oracle foreground process goes to sleep on a single block read wait event
      • <interrupt>
      • <request message DMA to Infiniband HCA “onto the wire”>
      • <wire time>
  • On Storage Server
    • <interrupt>
    • <request message DMA from Infiniband HCA into Cellsrv>
    • <Cellsrv thread scheduling delay>
    • Cellsrv gets request and evaluates e.g., specific block to read, IORM metadata, etc
    • Cellsrv allocates a buffer (to read the block into, also serves as send buffer)
    • Cellsrv block lookup in directory (to see if it is in Flash Cache, for this example the block is in the Flash Cache)
    • Cellsrv reads the block from flash Linux block device(Exadata Smart Flash Cache devices are accessed with the same library API calls as spinning disk.)
      • Libaio or LibC read (non-blocking either way since Cellsrv is threaded)
        • <kernel mode>
        • <block layer code>
        • <driver code>
      • <interrupt>
      • < DMA block from PCI Flash block device into send buffer/read buffer> THIS STEP ALONE IS 251us AS PER ORACLE DATASHEET
      • <interrupt>
        • <kernel mode>
        • I/O marked complete
        • <Delay until Cellrv “reaps” I/O completion >
    • Cellsrv processes I/O completion (library code)
    • Cellsrv validates buffer contents (DRAM access)
    • Cellsrv sends block (send buffer) via iDB (Infiniband)
      • <interrupt>
      • <IB HCA DMA buffer onto the wire>
      • <wire time>
  • Back on Host
    • <interrupt>
    • <IB HCA DMA block from wire into SGA buffer)
    • Oracle foreground process marked in runnable state by Kernel
    • <process scheduling time>
    • Oracle foreground process back on CPU
    • Oracle foreground validates SGA buffer
    • Oracle foreground chains the buffer in (for others to share)
      • <spinlocks, cache buffers chains, etc>
    • Oracle foreground locates data in the buffer (a.k.a “row walk”)

Wow, that’s a relief! We can now properly visualize what Oracle means when they speak of how “Database In-Memory Machine” technology is able to better the “World’s First Database Machine for OLTP.”

Summary
We are not confused over the difference between “database in-memory” and “in-memory database.”

Oracle have given yet another nickname to the Exadata Database Machine. The nickname represents technology that has been proven outside the scope of Exadata even 3 years ago. Oracle’s In-Memory Parallel Query feature is not Exadata-specific and that is a good thing. After all, if you want to deploy a legitimate Oracle database with the “database in-memory” approach you are going to need products from the best-of-breed server vendors since they’ve all stepped up to produce large-memory servers based on the hottest, current Intel technology–Sandy Bridge.

This is a lengthy blog entry and Oracle Exadata X3 Database In-Memory Machine is still just a nickname. You can license Oracle database and do a lot better. You just have know the difference between DRAM and SCSI block devices and choose best of breed platform partners. After all those of us who are involved with bringing best of breed technology to market are not confused at all by nicknames.

Sources:

  1. 25 years of Oracle and platforms experience. I didn’t just fall off the turnip truck.
  2. Exadata uses RDS (Reliable Datagram Sockets) with is OFED Open Source. The Synopsis of an Oracle-flavored “In-Memory” operation is centered on my understanding of RDS. You too can be an expert at RDS because it is Open source.
  3. docs.oracle.com
  4. Exadata data sheets (oracle.com)
  5. Google
  6. Expert Oracle Exadata – Apress
  7. http://www.oracle.com/technetwork/database/exadata-smart-flash-cache-twp-v5-1-128560.pdf
  8. http://www.oracle.com/technetwork/server-storage/engineered-systems/exadata/exadata-smart-flash-cache-366203.pdf
  9. http://www.aioug.org/sangam12/Presentations/20205.pdf

In other words, this is all public domain knowledge assembled for your convenience.

34 Responses to “Oracle Exadata X3 Database In-Memory Machine: Timely Thoughtful Thoughts For The Thinking Technologist – Part I”


  1. 1 Bart Sjerps November 5, 2012 at 7:53 am

    Reblogged this on Dirty Cache and commented:
    Awesome post by Kevin! Recommended read if you are interested in Oracle Exadata.

  2. 2 Noons November 5, 2012 at 3:46 pm

    Thanks for the great post, Kevin. Never underestimate Oracle marketing’s capacity to redefine reality, even if it means shooting their collective feet off!
    Same approach that makes them come over here and claim they can solve our “database performance problem” with their engineered systems. Upon which I immediately ask: ‘Which “performance problem?”‘, usually answered with: “Everyone has a database performance problem!”…
    (facepalm)

    The only value I see in their engineered systems is the ability to have a near optimal pre-configured hardware system with all needles pointing in the same direction. Instead of fighting three or four internal empire builders to get max performance specs on all layers: storage, transport, network, CPU, memory. Not an easy task, in my long experience of these things.

    On another note: there is a lot of value with EMC-FAST. But for example in a DW/ETL, large sequential batch processing situation, I fail to see how FAST can be of any help – other than forever chase behind where the real load is. It doesn’t predict load – it follows it.
    Note: that hasn’t stopped the local EMC rep from flogging it to our site!

    Instead of concentrating on more immediately useful matters like getting ALL of our servers on 8Gbps FC-cards to match the 8Gbps ports of our VMAX. Small details like these can have a huge impact on overall DW/ETL bandwidth capacity as opposed to OLTP-oriented IOPS – mostly useless for batch, sequential data processing.

    • 3 kevinclosson November 5, 2012 at 5:14 pm

      Hi Noons,

      Yeah, I have pretty close to zero experience with auto-tiering (e.g., EMV FACT) for DW/BI. I don’t think I’ve seen much in the literature about that use case for the technology…when I have my DW/BI hat on it is, of course, Greenplum. I brought up the tiering because of those words Oracle used in their press release suggesting Oracle data blocks are not totally fixed in place on HDD when in fact that is the case…there is no re-homing into persistent flash storage…just a natural flow into the flash cache based on demand…

      I’d just like the exaggerations to subside long enough for us to catch our breath.

    • 4 PetarByte December 14, 2012 at 7:16 am

      On the load prediction: That would be DBclassify from EMC. It works with FAST to move parts of the database to a higher tier when needed.

      • 5 Noons December 16, 2012 at 5:05 am

        “when needed” cannot possibly happen with a load that is essentially cyclic and sequential in nature. By the time it detects “when needed”, the database load is somewhere else and won’t come back in another 24-hours.
        Hence, a waste of time and resources for DW ETL workloads.
        Note that I fully and clearly qualified the type of workload. Which is a LOT more than what EMC does…

  3. 6 Oracle Admin November 6, 2012 at 12:11 am

    The big point you make here seems to be that Oracle is claiming their machine is in-memory but you say it is not because only DRAM is memory. You cite a google search of in-memory databases to prove your point.

    I just did a Google search of “Flash Memory” and came up with 164 million hits. It appears a lot of people other than Oracle consider flash to be a memory technology. Flash chips certainly look a lot more like memory chips than they look like disk drives to me.

    I think Oracle’s point is that most data now fits in-memory (either flash or DRAM) and memory is a lot faster than disk therefore the database is now faster than it was when it was on disk.

    That seems like a very simple and very valid point.

    Beyond the point about flash not being memory (despite millions of references to that effect), the other part of this seems to be saying that accessing flash as blocks across a network is a poor architecture because it is not as fast as accessing local DRAM chips.

    Why not just take this argument to it’s logical conclusion and say that accessing DRAM is a poor architecture since on-chip cache is so much faster. That argument seems to have the exact same fallacies as the flash argument.

    • 7 kevinclosson November 6, 2012 at 8:39 am

      “Why not just take this argument to it’s logical conclusion and say that accessing DRAM is a poor architecture since on-chip cache is so much faster. ”

      Oracle Admin:

      There is nothing logical about that comment nor is that any sort of logical conclusion to my argument. Processor cache is not memory. The corollary, however, would be Oracle to use the nickname “Database In-Processor Cache” and pile on a synopsis-worthy amount of overhead.

      I nearly didn’t let your comment through moderation based solely on your insinuation that the extent of my knowledge on the matter centers on that fun little google search angle at the begging of the post. However, I think your comment deserves discussion.

      You apparently didn’t read the synopsis of a “Database In-Memory” block access at the bottom of the post. I’m clearly not splitting hairs over the ever-morphing definition of the word “memory.” I let your comment through moderation because I suspect others might miss the point. What point? The entire point of this post is the synopsis of a “Database In-Memory” block access at the bottom of the post. Give that a fresh read and see if you still think I’m splitting hairs. If you do think I’m still splitting hairs then please tell all of us what else Oracle can plop into the access path for a block of “Database In-Memory” storage. Could Oracle shovel in a few more intra-node blocking IPC requests and still get the wool over your eyes? Maybe they could chisel the address of the block in stone and roll it over on a log and let cellsrv take a glance so it knows what block to fetch?

      Maybe I’m missing the point. I’m willing to accept that. Perhaps the state of the art is to see how much high-latency overhead Oracle can put in the path of a block access and still get some folks to accept the term “Database In-Memory.” So, please, tell us.

    • 8 Mike Philippens™ (@Mike_Philippens) November 8, 2012 at 6:48 am

      And that is exactly what Oracle (Larry Ellison) said at OOW last October. He didn’t say it’s an in-memory database, but stated that by replacing hard disks with either RAM, flash disks or SSD (and in third instance on the 500Gb disk array for ‘cold’ data) the database (or rather: datafiles and cachefiles) fits in memory (memory chips). This is faster than on a SAN or local disks.

      True, it’s a marketing term (what isn’t with products from a commercial enterprise?), but this article makes it look like Oracle promises something completely different. Just play back Larry’s keynote from OOW. I was there and there is no confusion in my mind about what he meant.

      • 9 kevinclosson November 8, 2012 at 9:11 am

        “by replacing hard disks with either RAM, flash disks or SSD (and in third instance on the 500Gb disk array for ‘cold’ data) the database (or rather: datafiles and cachefiles) fits in memory (memory chips).”

        @Mike_Philippens :

        I urge you learn the basic fundamentals about Exadata and also to re-read this post.

        I’ll limit myself to making 5 counterpoints regarding your “counterpoints”:

        1) HDD is not replaced in Exadata. Please re-read this post and look at the drawings.
        2) You state “SSD” in your reply. There is no SSD in Exadata.
        3) There is nothing in Exadata that is “500Gb”
        4) All data in Exadata persists on HDD whether ‘cold’ or hot.
        5) Regarding “fits in memory (memory chips)”, that is only the case in Exadata when a database happens to be small enough to be cached in Exadata Smart Flash Cache and even then, I’ll reiterate the fact that all data persists on HDD.
        6) “This” is not faster than accessing a block in a “SAN” (enterprise storage with tiering) where hot data is promoted to a persistent location on EFD and, if really hot, resides in the array controller DRAM cache. Contrast the “synopsis of a block access” in this post to a non-Exadata (e.g., skgfr()) read from an enterprise array or a flash array.

        This post is not a word game about a word game.

        • 10 Anantha November 9, 2012 at 6:34 pm

          @kevin, you’d be wrong in stating ‘all data persists on disk’. A hot block being written to can stay in flash forever without being destaged to disk. Check your facts.

          I used to enjoy this blog but now it has become an Oracle hatefest. Please revert to extolling the benefits of whatever is that you believe now; Greenplum. The value of Greenplum is not rooted in dissing Oracle. I haven’t seen you write about the finer aspects of Bizgress/Postgress. I want to hear your perspective on that, really.

          • 11 kevinclosson November 10, 2012 at 11:12 am

            > kevin, you’d be wrong in stating ‘all data persists on disk’. A hot block being written to can stay in flash forever without being destaged to disk. Check your facts.

            You, Anantha, do not appear to know the definition of the word persists as it pertains to Exadata. Do you aim to argue the fact that every block of data in an Oracle database stored in Exadata does not, in fact, have multiple copies of said block spinning on round-brown disks across multiple storage cells?

            I did not mention de-staging in this post because it is off-topic. The topic is Database In-Memory. But since you bring it up, let’s discuss.

            If the database is small enough to fit in the Exadata Smart Flash cache then, sure, dirty blocks (and multiple versions of same) can remain in Exadata Smart Flash Cache indefinitely. Do you recommend Oracle customers buy a solution that has 168 spinning disks so they cache a 22TB database (the size of the aggregate Exadata Smart Flash Cache)? After all, if it doesn’t all fit in flash cache there will be replacement (including de-staging if dirty).

            Anantha, Exadata PCI flash is used for accelerating datafile reads and writes and redo. LRU is going to cause de-staging. That, however has nothing to do whatsoever with the topic of this post which is Database In-Memory.

            For what it’s worth, I don’t hate Oracle. I despise a good deal of their go-to-market policies, over-selling and product marketing gaffes. If you have children I presume you don’t hate them when they misbehave. It’s quite similar.

            I allowed your vitriolic second paragraph through my moderation. That will be the last time though.

            • 12 Andrew not the Saint December 3, 2012 at 6:43 pm

              Kevin, I’m quite interested to read up about the case when the data is NOT written to spinning saucers. Are you aware of any official Oracle docs that describe how that works black-n-white?

              If only engineers would actually stick to the the engineering approach of RTFM rather than relying on hearsay, marketing and various gurus (e.g. *cough* Donald Burleson *cough*) the world would be a much better place.

              • 13 kevinclosson December 4, 2012 at 9:07 am

                Andrew: All data is “homed” on round spinning stuff in Exadata. The write cache of Exadata serves as nothing more than a delayed write to HDD. The delay can be arbitrarily long in duration as the data is protected due to ASM redundancy and the flash devices are persistent. As soon as demand pushes aged blocks out of the flash cache they are written to HDD. Once flushed (de-staged) to HDD only the primary mirror copy lingers (in a clean state) in the cache and all other flash copies (remember ASM normal or high redundancy) are invalidated. This is fine because ASM only reads the primary copy of mirrored ASM blocks. It doesn’t round-robin like traditional volume managers (e.g., VxVM plex reads).

            • 14 Anantha December 11, 2012 at 7:25 pm

              @Kevin, I was not arguing the ‘in-memory’ aspects at all, you’re misreading my comment. It simply corrected a mistake in a sentence that stated data persists to disk. As implemented in X3, disk becomes a backing store for flash.

              Like all other IT vendors Oracle is not foreign to exaggeration, they’re actually good at it ;-) I don’t pay much attention to marketing. That’s the reason I visit blogs like yours to learn.

              Regardless, you must admit the change in your articles. All I’ve to do is to read this very blog circa 2010 or 2011. I understand people change as new technologies emerge. However the tone and content of your blogs have changed, it used to be enlightening to read it. But now it is not.

              -Anantha-

              • 15 kevinclosson December 12, 2012 at 3:19 pm

                “@Kevin, I was not arguing the ‘in-memory’ aspects at all, you’re misreading my comment. It simply corrected a mistake in a sentence that stated data persists to disk. As implemented in X3, disk becomes a backing store for flash.”

                “[…] mistake in a sentence that stated data persists to disk” and who wrote that sentence? You lost me.

              • 16 robinschatterjee December 26, 2012 at 12:32 am

                Hi Kevin,
                I was trying to verify this algorithm because I don’t see it mentioned any where in the documentation and it seems to me that it means that effective available cache should be reduced by the amount of dirty blocks in flash cache ( as there are two copies ). Unfortunately 1) cellcli does not seem to display a dirty flag. 2) I assume the only way to figure out a lot of this is from ASM. IS there any published material on the way this works ?
                Thanks

  4. 17 Daniel Da Meda November 6, 2012 at 7:19 am

    Hi Kevin,

    Thanks a lot for taking your time to write such a facinating post. As I was reading, I felt like a litle 8K block going through the loops, twists and chains all the way form the Flash Cash to the Buffer Cache. It is always important to hear all sides of the story. I presume your post is going to make some considerable noise around the Oracle comunity.

    Regards

    Daniel Da Meda

  5. 18 Vic Slaidins November 8, 2012 at 2:18 am

    Hi Kevin and thank you for this interesting post. I am an IT professional but not as technical as some, so to me your pictures painted a thousand words. I have recently researched SAP HANA and it may assist other readers if you compare the HANA architecture with Exadata as to my understanding HANA is a true In-memory database that only uses HDDs for data persistence when powered off. You did make a passing mention of HANA, but a picture comparison might be useful.

    Regards
    Vic

    • 19 Rob Klopp November 8, 2012 at 12:45 pm

      As an engineer we have to be able to define technical terms carefully and
      use them accurately.

      To a programmer, or to a program like RAC, memory is a resource
      allocated explicitly with an instruction or implicitly by the programming language as the result of an instruction.

      A peripheral device is accessed via an I/O request. If the peripheral
      device includes some RAM we would not rationally use the words “in-memory” to describe a program that uses the device. For example, a SAN device has loads of RAM onboard… But when I take my program that has been using a HDD and point it to a SAN device I would not now call my program an in-memory technology.

      The Exadata database program is RAC. Exadata extends RAC adding a shared storage subsystem network-attached to the RAC layer. It is, from an engineering perspective, a purpose-built SAN. It fact, it is a SAN from Oracle’s perspective as well… Which is why its performance was compared to EMC SAN when Exadata X3 was introduced.

      When Oracle pointed their code to a SAN with RAM onboard they did not
      develop an in-memory software technology. How can data-on-SAN be data-in-memory in any reasonable use of the term?

      When LE uses the misleading language and then immediately follows with a reference to HANA, a technology that is actually a purpose-built in-memory technology, it becomes reasonable to think that maybe the language was meant to mislead…

      IMHO it is fair for Kevin to call out misleading language AND point out the engineering realities.

      • 20 kevinclosson November 9, 2012 at 12:40 pm

        Thanks Rob,

        I think it is every bit as important for consumers to pay attention to words..in fact, even more so than engineers. Engineers know when marketing are stretching the truth. A consumer, on the other hand, may not. I aim to help the IT consumer.

        Since the acquisition of Sun, Oracle’s marketing claims have routinely swollen well beyond the point of absurdity. I merely aim to provide factual information to help folks cut wheat from chaff as it where. Word-gaming like “Database In-Memory” deserves scrutiny.

        I think the following is relevant: https://twitter.com/kevinclosson/status/266985899806576640/photo/1

  6. 21 Andrew not the Saint December 3, 2012 at 6:35 pm

    Schooled! Great post… In addition to the obvious sarcasm, I love the subtle one too e.g. “After all, Exadata is the World’s First Database Machine for OLTP and now that it is also Database In-Memory technology it might interest you to see how that all works out.”

  7. 22 Matthew Morris December 4, 2012 at 8:53 am

    Excellent work again Kevin. Oracle is evolving into the EF Hutton of Database management. Where if they say it must be true.

    In-memory functions are vastly different than the traditional “block & tackle” storage IO that Oracle RDBMS still uses today.

    And by extension Exadata Storage Cells.

    Keep up the great work.

  8. 23 Alex December 19, 2012 at 7:05 pm

    Thanks you very much for the great and very detailed post.

    P.S. It’s funny to read comments of Oracle’s zealots which have a butthurt every time when someone dispels another marketing hype of Oracle.

  9. 24 Marco Ullasci February 13, 2013 at 8:50 am

    Hi Kevin,
    given the fact that the flash memory is managed at the linux level as a block device can’t the DBA explicity allocate it, using ASM, as if it was a regular disk?

    In this case two tiers of storage would exist inside the cell and with scripts the DBA could move (not copy) old data (partitions) out of flash and into disks as the space becomes needed for fresher data.

    As mirroring becomes needed to avoid loss of data in case of HW failure the amount of space useable in flash would be reduced compared to the cache use model but still it will be tiering albeit not automatic.

    • 25 kevinclosson February 13, 2013 at 11:38 am

      Hi Marco,

      Yes, of course. If PCI flash–in the database host–is presented as a block device you can add it to the database as a datafile or as an ASM disk or even as a Database Smart Flash Cache. Flash in Exadata is presented to the cell software as a block device but the database can’t see that fact…and that fact is the basis of my critique of referring to Exadata X3 as “In-Memory Database Machine.”

      Flash most certainly does not, however, *need* to be treated as block storage. Please refer to the following primer on NVMe: http://en.wikipedia.org/wiki/NVM_Express

      • 26 Rob Klopp February 13, 2013 at 12:08 pm

        I believe that NVM Express is a PCIe-based protocol that is still block storage… see http://www.nvmexpress.org/index.php/download_file/view/18/1/

        – Rob

        • 27 kevinclosson February 13, 2013 at 2:13 pm

          Hi Rob,

          Thanks for stopping by. You must be replying to the following statement specifically:

          Flash most certainly does not, however, *need* to be treated as block storage.

          Yeah, I probably meant to say “treated as SCSI block storage.” What I was trying to point out was that NVMe opens the future to accessing flash with memory semantics as opposed to physical I/O semantics while still allowing NVMe-specific HW to be grafted into the legacy SCSI data flow topology. And *indeed* today allows one to implement PCIe Flash storage without SCSI madness.

          Let me just put it this way, SOP (SCSI over PCI) is probably not the future to addressing PCI flash with memory semantics :-)

          In short, what I rant about is this notion that Oracle refers to blocks of disk copied into blocks of PCI flash accessed via legacy SCSI through physical I/O APIs as “In-Memory.” I presume you and I agree on how absurd a notion that marketing-misfire really is!


  1. 1 Oracle 11g R2 Grid Infrastructure installation on 2 node cluster using Virtualbox « [SbhOracle] Saurabh Gupta's Oracle Blog Trackback on November 4, 2012 at 8:37 pm
  2. 2 More on Exadata X3 “Database In-Memory” (but not by me) « flashdba Trackback on November 6, 2012 at 11:20 am
  3. 3 Are The Bells Tolling For Oracle? | SQLRockstar | Thomas LaRock Trackback on November 16, 2012 at 9:57 am
  4. 4 Gone in a flash: Exadata is not In-Memory | IBM Trackback on November 26, 2012 at 11:32 am
  5. 5 A Look Back at 2012 « Database Fog Blog Trackback on December 30, 2012 at 11:38 am
  6. 6 My 2 Cents: Oracle Exadata 1Q2013 « Database Fog Blog Trackback on February 4, 2013 at 7:22 am
  7. 7 Oracle Database 12c Release 12.1.0.2 – My First Observations. Licensed Features Usage Concerns – Part I. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 24, 2014 at 1:12 am

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,176 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,176 other followers

%d bloggers like this: